how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 18347 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / renu
Row_number() works on SQL 2005 and upper version, if u r
trying it on 2000 it will not work.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How to defragment indexes with alter index ... Reorganize?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
What is constraints and its types?
What is difference between getdate and sysdatetime in sql server 2008?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is the use of keyword with encryption. Create a store procedure with encryption?
What is the difference between DATETIME2 and DATETIME?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is the difference between for trigger and after trigger?
How to stop a loop early with break statements in ms sql server?
What are extended events in sql server?
What are data driven subscriptions?
What is data file in computer?
What is inner join? Explain with an example?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
