4,707 questions
SELECT @ID = ('1111','2222') is not correct. Try the following script if your SQL server is 2016, 2017 or 2019:
DECLARE @ID VARCHAR(100)
SET @ID = '1111,2222';
SELECT value FROM STRING_SPLIT(@ID, ',');
For you case:
SELECT * INTO TAB1 FROM TAB2 WHERE ID IN (SELECT value FROM STRING_SPLIT(@ID, ','))