What happens when converting big values to numeric data types?

1230

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1446

What is set nocount on?

997

List the different index configurations possible for a table?

985

what's the difference between delete table and truncate table commands? : Sql server database administration

1041

What are scalar functions in sql?

1213

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

948

Explain Capacity planning to create a database? and how to monitor it?

4251

What is difference between oltp and olap?

1099

What is catalog views?

1123

What is inner join in sql server joins?

1107

What is scan table/view and seek table/view when its occurs? : sql server database administration

1101

How to create a new login name in ms sql server?

1113

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1116

What are the different types of columns types constraints in the sql server?

1137