We need to perform what steps in the following order to work with a cursor?
No Answer is Posted For this Question
Be the First to Post Answer
What is data source object?
Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.
Define the one-to-one relationship while designing tables.
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
Why are sql functions used?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance
Explain transaction server consistency?
What is Check point? Explain in Brief what it will do?
According to you what goes into making the best database administrator? : sql server database administration
Define candidate key, alternate key, composite key.
13 Answers Infosys, Software India,
How do you manipulate data?