Answer Posted / vimal
dbcc traceon 302
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Is resultset an interface?
What are the acid properties?
Why I can not enter 0.001 second in date and time literals in ms sql server?
Delete duplicate rows without using rowid.
Explain the truncate command? : SQL Server Architecture
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
List the different types of joins?
Do you know what are acid properties of transaction?
What is the difference between osql and query analyzer?
What is the purpose of optimization?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is the openxml statement in sql server?
Explain differences between web edition and business edition?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is an index in sql?