SQL Server table variables not supported | SELECT columnName FROM @table #911

Activity

1. cdandoy commented on Dec 21, 2019

   

   cdandoy

   on Dec 21, 2019

   Last edited by cdandoy

   Author

   More actions

   Here are a couple of use cases:

   DECLARE @tableName TABLE (id INT);
   
   INSERT INTO @tableName VALUES (1);
   UPDATE @tableName SET id=2;
   UPDATE t SET id=3 FROM @tableName AS t;
   SELECT * FROM @tableName;
   DELETE FROM @tableName;
   DELETE t FROM @tableName as t;
   
   
   -- not valid:
   -- SELECT @tableName.* FROM @tableName;
   -- SELECT 1 INTO @tableName;
   -- TRUNCATE TABLE @tableName;
   -- CREATE INDEX idx ON @tableName(id);
   
   
   
2. manticore-projects

   closed this as completedin #2581on Sep 11, 2026