What happens if null values are involved in datetime operations?

1019

What is the process of normalising?

1042

How many null values we can have in a unique key field in sql server?

1004

What is user defined datatypes and when you should go for them?

1064

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1183

What are recommended options to be used while using db mirroring? : sql server database administration

1217

How would we use distinct statement? What is its use?

1117

You want to implement the many-to-many relationship while designing tables. How would you do it?

1043

How do you migrate data from mssql server to azure?

167

Can we add an identity column to decimal datatype?

1040

What will happen if a column containing char type data is changed to the nchar data type?

1145

What do you mean by subquery?

1140

Explain acid?

1137

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

934

What is page in sql server?

988