Auto Incremental Value in Query

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Auto Incremental Value in Query

Message

From

06/07/2003 21:31:41

Sergey Berezniker
New York, United States

06/07/2003 21:16:58

Rene Lovino
Bigfoot Global Solutions, Inc
Cebu, Philippines

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Auto Incremental Value in Query

Miscellaneous

Thread ID:

00807090

Message ID:

00807325

Views:

>I guess Mike is refering to the table variable in SQL2000 as the following syntax:
>declare @ltables table (nrecno numeric identity(1,1), citemno char(20))

I'm well aware what the table variable is. How is it relevant to the problem at hand?

--sb--

Map

View

Click here to load this message in the networking platform