How to check parameter value in stored procedure sql server?
How you can add messages to the nt event log from within a stored procedure?
Can we use custom code in ssrs?
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What does select 1 mean?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
How do you make a trace?
what is Data Transformation Services (DTS) ?can u explain me in detail?
Do you know the isolation level that sql server support?
How optimize sql query with multiple joins in sql server?
Explain the properties of a relational table?
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.