Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

975

How to write an inner join with the where clause in ms sql server?

1079

Name some of the open source software that you can use in alternative to SSR?

159

What are the steps you should follow to start sql server in single-user mode?

896

What is a fill factor?

1078

How to drop an existing user defined function in ms sql server?

1022

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

976

What is merge replication?

1098

define and explain the differences between clustered and non-clustered indexes.

1189

How to create a simple stored procedure in ms sql server?

1023

How does clustered and non clustered index work?

919

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

983

When would you use sql joins?

949

What is a ddl statement?

905