2
Shouts
spam Shout it Mute it

Table variables in sql server 2005
posted by kcherupakcherupa 864 days, 12 hours, 20 minutes ago
Monday, January 11, 2010 10:20:26 AM GMT

Table variable is almost similar to the temporary table in sql server 2005. Table variables are replacement to temporary tables. The following syntax shows how to define a table variable.

declare @Customer table ( CustomerID int identity(1,1), CustomerName varchar(100), CompanyName varchar(100), Address varchar(250) )

You can notice the syntax to define a table variable is similar to the syntax to normal table definition. declare keyword is used in place of create keyword. And table name is p...

category: SQL | clicked: 0 | | source: cherupally.blogspot.com | show counter code

No comments yet, be the first one to post comment.

To post your comment please login or signup