table datatype in sp sql server

[Sonia Gupta]

can i use the table datatype in stored procedure sql server? actually i have few rows in the gridview asp.net 2.0 , i want those rows data in the stored procedure. is there any table like datatype available?

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

[Joe 2]

Sonia Gupta wrote:

is there any table like datatype available?

Yes, table variables are available.

Declare @table_name Table(column_name1 datatype,column_name2 datatype)

Ref: Table[^]

Give a man a fish, he'll eat for a day. Teach a man how to fish, he'll eat for lifetime. Pradeep Joe