![]() ![]() WHERE p.ProductID IN ( SELECT n FROM then using management studio only I executed this procedure DECLARE integer_list_tbltypeĮXEC get_product_names it is giving me correct output. Then I wrote stored procedure CREATE PROCEDURE get_product_names integer_list_tbltype READONLY AS SELECT p.ProductID, p.ProductName So I created user-defined data type using Microsoft SQL Server Management Studio.ĬREATE TYPE integer_list_tbltype AS TABLE (n int NOT NULL PRIMARY KEY) ![]() This link says to use table-valued parameter. When I google this problem then I found this link In my application I want to execute query like SELECT * FROM tbl WHERE col IN can have variable no of values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |