What is the datatype returned by count(*)
Post New Answer View All Answers
Why does sql studio use a single registered database repository? : sql server management studio
Do you know what are acid properties?
What is Lock table in SQL?
What is a recursive stored procedure in sql server?
What stored procedure would you use to view lock information?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is page-level compression?
What are the new scripting capabilities of ssms? : sql server management studio
What is the difference between a fill factor of 100 and 0?
Distinguish between nested subquery and correlated subquery?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What are the pre-defined functions in the sql server?
How you trouble shoot when any job fails
Can two different columns be merged into single column? Show practically?