How you can get a list of all the table constraints in a database?
What are the different types of subquery?
How to include date and time values in sql statements?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
can any body tell me how to know the password of current user in sql server
When would you use it?
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.
What is the difference between indexing and hashing?
In which tcp/ip port does sql server run? Can it be changed?
What is difference between line feed ( ) and carriage return ( )?
What is the purpose of the master database?
What is the use of “join” in sql server?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?