Do you know what is a with(nolock)?
No Answer is Posted For this Question
Be the First to Post Answer
What happens if null values are involved in string operations?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Explain about unique identifier data type in sql server?
What is table constraint?
How to loop through the result set with @@fetch_status?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
Give a example to search fr a string in all stored procedure in sql server.
What are the difference between primary keys and foreign keys?
Define indexes?
what is physical sort data and logical sort data in index?
What is data source document?
What is the difference between a local and a global variable?