Why do we need normalization?

923

What is ddl command?

972

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1011

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1075

How to run queries with sql server management studio express?

1092

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2105

Write a SQL query to delete a table?

1137

Differentiate between a primary key and a unique key.

1069

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1147

How to select some specific rows from a table in ms sql server?

1005

Can we join two tables without primary key?

1051

what is dbcc? : Sql server database administration

1031

What is difference between temp table and cte?

1019

Can a rule be bound to any column of any data type?

963

Who developed sql server?

938