Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
 Posted - 2006-09-11 : 04:16:31
|
| HiI want to find current row of executed query means current row_id How it will done.Ranjeet Kumar Singh |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-09-11 : 04:20:24
|
what do you mean by current?do you need maybe scope_identity() function? It's used to get the last inserted identity value in the batch.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-11 : 04:22:34
|
| [code]Use PubsSELECT (SELECT COUNT(i.au_id) FROM pubs..authors i WHERE i.au_id >= o.au_id ) AS RowID, au_fname + ' ' + au_lname AS 'Author name'FROM pubs..authors oORDER BY RowID[/code]Chirag |
|
|
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
Posted - 2006-09-11 : 04:57:24
|
| HiI want to perform some different task to row wise.I have no primary key in my table.I want Task 1 at first row,Task 2 at second row ,.........Ranjeet Kumar Singh |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-11 : 05:02:18
|
| Ranjeet, Please have a look at the following link and post accordingly. http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxif you post, in that manner then i am sure that some one from here will surely give you extactly what you want..Since its you who are working on that Assigment, and you have complete idea about it, where as we only know as much as you post. .. Chirag |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-09-11 : 06:01:26
|
| ma only question is:Why don't you have a Primary Key? don't you know better?Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Find Current row of executed query in sql server 2