How to use SQL Server Management studio - "Execute Stored Procedure" for User Defined Table Types? -
i trying right click stored procedure in sql server management studio 2012 , trying execute stored procedure accepts single parameter of type tbltype_xxx
user defined table type. when try pass single value error
msg 206, level 16, state 2, procedure uspgetxxxxxxxx, line 0 operand type clash: int incompatible tbltype_xxx
how can specify parameter of type tbltype_xxx
in sql server management studio -> execute stored procedure ui?
tbltype_xxx
contains 1 column of type int
you need declare table variable, insert data if needed, call stored procedure not using @parameter = 1
format:
declare @return_value int, @tblparameter tbltype_xxx insert @tblparameter values (1) exec @return_value = [dbo].[uspgetxxxxxxxx] @tblparameter
Comments
Post a Comment