I am trying to insert data into a table based on a variable, but SQL Server is not recognising the table in the variable.
INSERT INTO @tableNameH
SELECT * FROM @tableName;
It this not supported in T-SQL?
Asked
Active
Viewed 43 times
0
Uwe Keim
- 38,279
- 56
- 171
- 280
Daniel Frost
- 358
- 1
- 13
-
1You are trying to insert into a variable, not a table – Giorgos Betsos Jan 09 '21 at 16:36
-
but the variable is the table name ^ – Daniel Frost Jan 09 '21 at 16:37
-
3You cannot use a variable name as a table name – DavidG Jan 09 '21 at 16:38
-
1It is not a table name. Here is table variable DECLARE @InTable TABLE(ID INT NOT NULL, VAL VARCHAR(100)); – Sergey Jan 09 '21 at 16:39
-
1And you selected data to be inserted from the same table? – Giorgos Betsos Jan 09 '21 at 16:39
-
1Yes as DavidG says, dynamic SQL is the way to go if you want to set the table name at execute time. – Peter Smith Jan 09 '21 at 16:42
-
Thank you! I needed the EXEC :) – Daniel Frost Jan 09 '21 at 16:43
-
1@PeterSmith Then, you know, vote to close... – DavidG Jan 09 '21 at 16:49
-
1Careful, the accepted dupe is open to injection. You should be using `QUOTENAME` to properly quote dynamic objects, shown in [this answer](https://stackoverflow.com/a/23317992/2029983). – Larnu Jan 09 '21 at 17:19