How to create new databases with "create database" statements?

1068

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

1035

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1143

Can select statements be used on views in ms sql server?

1117

How use inner join in sql server?

1191

What are the different types of normalization?

1222

How can we determine what objects a user-defined function depends upon?

1076

What is openxml in sql server?

1225

What are the differences between ms sql server & oracle?

1118

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

940

Do you know what are different types of replication in sql server?

1157

What are security principals used in sql server 2005?

1040

How to join two tables in a single query in ms sql server?

1062

How to select true false based on column value in sql server?

1084

How to modify the underlying query of an existing view?

1033