Write the queries for commands like Create Table, Delete table, Drop Table etc.
Do you know how to store and query spatial data?
What happens when converting big values to integers?
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,
How to get the definition of a user defined function back?
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,
What is SQL Server?
What is default constraint?
Explain what is “asynchronous” communication in sql server service broker?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is an execution plan? When would you use it?
How do you troubleshoot SQL Server if its running very slow?
What are the authentication modes in SQL Server?