what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
1651Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
IBM,
1977A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?
7 7565cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
2 3946
What is the main purpose of ms access?
What are sql triggers used for?
Explain the significance of the & and && operators in pl sql.
What is the maximum length a text field can be in access?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What purpose does the model database server?
Can we insert data if clustered index is disabled?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
Is database a data structure?
Write a SQL command to insert and update only a particular field?
explain the difference between delete , truncate and drop commands? : Sql dba
Explain what is dbms?
What do you understand by mirroring and mention the advantages of the mirroring?
Where can you add custom error messages to sql server?