Autonumber field

[Guest_imported]

hi all

I need to make a query with two fields one of which is supposed to be just an incrementing integer

I assume it supposed to look like this:

SELECT AutoNumber As Id, PrintLetter
From Letters

this code doesnt work, how do i create an autonumber field

Thanks
Alex

 

[tlbroadbent]

You cannot use AUTONUMBER in SQL Server. You can't define a column as Identity in SQL queries. You could execute a procedure like this. You'll need to supply data type and size of the PrintLetter column.

Create procedure PrintLetterQuery As

Create Table #t (RecID Int Identity(1,1), PrintLetter <data type>(<size>))

Insert #t (PrintLetter)
Select PrintLetter From Letter

Select * From #t
Go Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

&quot;I'm not dumb. I just have a command of thoroughly useless information.&quot; - Calvin, of Calvin and Hobbes