Latest Answer : set con=createobject("ADODB.connection")set rs=createobject("ADODB.recordset")set cmd=createobject("ADODB.command")con.provider=(Microsoft.jet.oledb.4.0")con.open "select the path of the database"rs.open "enter ...
How can a user access all the Data Dictionary Views - Say If Scott user needs to be given the privilege of viewing all the Data Dictionary Views, What needs to be done ?
I have student table with fields name,marks1,marks2,marks3 fileds. i want the output as the student details and thier totals and their rank in class, i.e calculated at runtime.please send me the query in sql server or oracle
Hello,I need some info, that is it possible to find or make query ,that if we know the data stored in a table but don't know the field name in which the required data is stored.ExampleTable having fields like columnA, columnB, columnC, columnD,..........columnN and all have the same dataType. and you dont know in which field your data exists.suppose some data like e.g. "BackMan" exists in any Field of the table but we don't know in which Field this information is store.Is
Subform in ms access having data from linked table to sybase, gives odbc error.my data in of type text. Kindly throw some light. Thanks in advance. Karira, S.
Will the ‘View’ get refreshed immediately when you update a database table. If it doesn’t get refreshed immediately, what method you use to refresh it ?
1. imagine there are 2 tables first table(personal table) consist of : name, age, official address, personal addresssecond table(address table) consist of : street, city, state, phone number, country, zip codeHere personal address and official points to address table1. create the above table2. find and goup the name of the person who lives in same zip code using personal addressIf somebody answer this, it would be a great help.
I have my DB2 database on mainframes and I am trying to replicate the same database on Windows server. I have loaded the table definitions to the Windows servers but looking for a way to export data from Mainframe DB2 tables to Windows server tables (Table definitions in both servers are same).I am looking for an easy and efficient way which can take care of nulls, strings, delimiters etc while exporting.Any help!
I have one teacher table containing school code,teacher details like sex,name etc.I want to count those schools having only male teachers(ie no female teachers).Bcoz corresp to one school there can be multiple records.Its very urgent.Pls help me if somebody has soln?(i need the SQL query full code)
Hi, my question isIn a screen i have 1 datagrid with the data i have to do 2 things1)Save the data in the grid to the CSV format2)Load the Saved CSV format file into the grid as well as into the Sql Server database table at a time..
