What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1141

Explain what is the purpose of sql profiler in sql server?

1076

What happens if null values are involved in string operations?

992

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

962

What do you understand by coalesce in sql server?

1069

What xml support does the sql server extend?

1012

What are the different Topologies in which Replication can be configured?

1183

What is bcp? When does it used?

976

What is the tcp/ip port on which sql server runs?

1160

What is triggers and its types?

1009

Write the syntax for stuff function in an sql server?

1027

Tell me what is sql profiler?

1029

What are the advantages of partitioning?

1128

What is the use of group by clause?

942

How do you clear a log file?

1048