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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-30 : 08:08:45
|
| Andrio writes "HiI have many tables with heavy data, but tables don't have identity columns.And my assignment is to select a SEQUENCE number (1,2,3,....,n) "as a column" with the rows fetched with a simple select statement.Sure for your immediate replyregards" |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-06-30 : 08:41:06
|
quote:
Originally posted by AskSQLTeam
Andrio writes "HiI have many tables with heavy data, but tables don't have identity columns.And my assignment is to select a SEQUENCE number (1,2,3,....,n) "as a column" with the rows fetched with a simple select statement.Sure for your immediate replyregards"
I didn't know some data weighs more than others...  Anyway - we don't answer homework 'assignments'. Try it, post your attempt, and we will give some pointers if necessary.Corey Co-worker on The Wizard of Oz "...those three midgets that came out and danced, the freaked me out when I was little. But they are ok now."  |
 |
|
|
|
|
|
How to get Sequence Number with Select Only?