SQL SERVER 2008 Stored procedure pass-table parameters

?

The recent project used the stored procedure to pass in the table type parameter.

-- Defining table Types Create type T_table_type as Table ( ID int, name varchar(+), Sex varchar(2) ) ? Go -- create a stored procedure CREATE PROC u_test (@tt_table_typereadonly) As Begin ???? Select * from @t ???? End ? -- call a stored procedure Declare @t T_table_type ? Insert into @t values (1,' A ',' F ') Insert into @t values (2,' A ',' F ') Insert into @t Values (3,' A ',' F ') Insert into @t Values (4,' A ',' F ') ? exec u_test@t

SQL SERVER 2008 Stored procedure pass-table parameters