How to find which stored procedure is currently running in sql server?
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
What is hot add cpu in sql server 2008?
Difference between Function and Stored Procedure?
What is the difference between update lock and exclusive lock?
Why I can not enter 0.001 second in date and time literals in ms sql server?
How you trouble shoot when any job fails
Your table has a large character field there are queries that use this field in their search clause what should you do?
which backup strategy you are following at ur company
Define left outer join in sql server joins?
Explain how many normalization forms?