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

How to use subqueries in the from clause in ms sql server?

0 Answers  


Explain how to integrate the ssrs reports in application?

0 Answers  


What are the advantages of sql stored procedure?

0 Answers  


Why are views required in the sql server or in any other database?

0 Answers  


How do you create type- insensitive operator?

0 Answers   EXL,






What is sql server query analyzer?

0 Answers  


How to use "begin ... End" statement structures in ms sql server?

0 Answers  


diffrence between function and procedure

5 Answers   Wipro,


How to create view in stored procedure sql server?

0 Answers  


What is data modification?

0 Answers  


Does a server store data?

0 Answers  


how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,


Categories