Stored procedure with multiple parameters (including multiple values ​​in parameters)

CREATE PROCEDURE [DeleteQueryLog] @QUERYLOGID VARCHAR (1000), @ QUERYLOGID2 VARCHAR (1000) ASBEGIN DECLARE @SQL VARCHAR (1000) SET @SQL = 'DELETE FROM SendSMS WHERE ID IN (' SET @SQL = @SQL @QUERYLOGID @ QueryLogid2 set @SQL = @SQL ')' Execute (@SQL) endGO