Message
From
13/08/2003 14:31:58
Sergey Berezniker
New York
,
United States
To
13/08/2003 14:26:52
Darren Ramsay
Gerrity Computers
Concord
,
Ontario
,
Canada
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re:
Update query not listening?
Miscellaneous
Thread ID:
00819873
Message ID:
00819887
Views:
13
>I cannot make it an identity column. Is there another 'easy' way of numbering rows?
Sure
DECLARE
@sq
int
SET
@sq =
0
UPDATE
#d2
SET
@sq=@sq+
1
, order_seq=@sq
--sb--
Previous
Reply
Map
View the map of this thread
View the map of this thread starting from this message only
View
View all messages of this thread
View all messages of this thread starting from this message only