What is difference between rownum and rowid?


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

Post New Answer

More SQL Server Interview Questions

Explain SELF JOIN ?

3 Answers   ADP,


Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  


What are the limitation of the Online Index Rebuild Operation?

1 Answers  


What are the events recorded in a transaction log?

0 Answers  


what are the advanced features in sql 2008?

2 Answers   Wipro,






You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  


what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  


What is the disadvantages of index?

3 Answers   TCS,


What are the two modes of authentication in sql server?

0 Answers  


what are default? Is there a column to which a default cant be bound?

1 Answers  


wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

1 Answers   Idea,


Why would you call update statistics?

0 Answers  


Categories