sql server - Pass datatable as paramater in stored procedure -

is possible pass datatable parameter stored procedure ? so, like

exec mystoredprocedure @mydatatable

i using sql server 2008.

you need create user-defined table type first.

-- create data type create type udtt_table table  (     column1     int,      column2     varchar(10),      column3     datetime ) go

you can use user-defined table type in stored procedure following,

create procedure usp_user (     @usertable  udtt_table readonly ) ... ....

JVParth