Difference between rowid and rownum in SQL?

Question Posted / srikanth

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

More SQL Server Interview Questions

What is the difference between ddl and dml?

What is self contained multi valued query?

Explain the new features of SQL server 2000?

What is a Stored Procedure?

What is meant by referential integrity?

How is sql used in sql server?

what is a check constraint?

what is Data Transformation Services (DTS) ?can u explain me in detail?

What is a Trace frag?Where can we use this?

Tell me when is the update_statistics command used?

Explain cdc and sql injection?

Can we call stored procedure in trigger?

For more SQL Server Interview Questions Click Here