How to refer to a variable inside the table?

[nljoco]

If I have the following code:
DECLARE @recordItem TABLE( field1 int, field2 int)

How will I refer to field1?

 

[tlbroadbent]

You reference a table variable like you reference a table.

Select Field1, Field2
From @recordItem
Where field1=1

Update @recorditem
Set field2=92
Where field1=3

Insert @recorditem (field1, field2)
Values (1, 45) Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.