wht's the differece between sqlserver05 and sqlserver2000
Answer Posted / monal
SQL 2005: Database Snapshot, SNAPSHOT Isolation
Level, .NET, CLR, Online Backup, Online Index Building
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you explain the disadvantages/limitation of the cursor?
What are different types of database indexes?
What is a primary index?
How can you list all the columns in a database?
What is exporting and importing utility?
What are logical/boolean operations in ms sql server?
Can the query output be sorted by multiple columns in ms sql server?
Do you know what is replace and stuff function in sql server?
Explain system rowset functions?
can an order by clause be used in a creation of a view?
What is inner join in sql server joins?
What is the difference between cartesian product and cross join?
How to create a testing table with test data in ms sql server?
What is the dbcc command and why is it used?
What is the difference between count () and rowcount ()?