كيف ادخل أكثر من متغير الى Stored Procedure

Use sp_execute_sql to evaluate the sql query and pass the list of ids

as a string.this list will get evaluated inside the query

CREATE PROCEDURE test

@list varchar(500)

as
DECLARE @query NVARCHAR(500)
Set @query = N'Select*From table Where Id in (' + @list + ')'
EXEC sp_executesql @query

calling :

exec test "1,2,3"

will get you all the records which id is in the list

Madani

شكراً جزيلاً أخ مدني و ماقصرت