What is difference between count (*) and count column?
Can we use where and having clause together?
How will you optimize a stored procedure optimization?
Define inner join? Explain with an example?
hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq
How to insert new line characters into strings?
What are the steps you will take to improve the performance of a poor performing query?
Explain the difference between functions and stored procedures in sql server?
How to provide values to user defined function parameters?
How check triggers in sql server?
How will you go about resolving deadlocks?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
How to generate random numbers with the rand() function in ms sql server?