Difference between rowid and rownum in SQL?



Difference between rowid and rownum in SQL?..

Answer / yash

the difference between ROWNUM and ROWID is that ROWNUM is temporary while ROWID is permanent

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  


What are the default system databases in sql server 2000?

0 Answers  


Can you move the resources after pausing the node? : sql server database administration

0 Answers  


Do you know the isolation level that sql server support?

0 Answers  


can you any body tell me which service pack is installed in the sql server?

3 Answers  






What is best institute to Learn DotNET And SQL in chennai?

0 Answers  


What is a trigger?

4 Answers  


Explain about Joins?

0 Answers   Infosys,


What is a SQL Server Temporary Table?

1 Answers   Wipro,


what is checksum in sql server.........???

0 Answers   TCS,


What are the advantages of policy management?

0 Answers  


What is stored procedures?

0 Answers  


Categories