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

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -