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 - 2003-12-22 : 08:17:01
|
| Nahid writes "How can i generate auto number of a primary column using trigger in SQL server 7.Please send me the code" |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-12-22 : 08:46:20
|
| How would you like that sir? DHL Express or Fedex Next Day? I am sorry UPS is too busy for the holiday season...OwaisWe make a living out of what we get, but we make a life out of what we give. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-12-22 : 09:58:35
|
| See identity in bol.To use a trigger it should probably be an instead of trigger otherwise you will have to allow nulls and possible duplicates.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
SQL server 7.0 about trigger