What is the purpose of update statistics and scope_identity() function?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Which are the important points to note when multilanguage data is stored in a table?

0 Answers  


Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,


Give me any three differences between Truncate and Delete.

0 Answers   Genpact,


can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  


How to write stored procedure to update the data in 10 tables

4 Answers  






What is BCP? When do we use it?

2 Answers  


what is an extended stored procedure? : Sql server database administration

0 Answers  


Where cross join is used?

0 Answers  


What happens if null values are involved in arithmetic operations?

0 Answers  


what is difference between primary key and Unique

8 Answers  


WHAT IS UNIQUE IDENTIFIER DATA TYPE?

2 Answers   Sparsh,


What happens if time-only values are provided as date and time literals?

0 Answers  


Categories