Options
INSERT INTO @TempTable
MikeONeill
Posts: 131
Hi
If I type INSERT INTO <tableName> I get all the column Names and Stubs for all Values of these column names
If I do the same with INSERT INTO @TempTable , I just get the first column and Values for first column only
Is this a BUG or by design??
SSMS 2005 Sql prompt 3.9.0.43 Pro
If I type INSERT INTO <tableName> I get all the column Names and Stubs for all Values of these column names
If I do the same with INSERT INTO @TempTable , I just get the first column and Values for first column only
Is this a BUG or by design??
SSMS 2005 Sql prompt 3.9.0.43 Pro
Comments
Can you please check your syntax. You appear to be referencing a variable called TempTable. The following syntax creates a temporary table:
USE [databasename]
GO
CREATE TABLE #TempTable
(Col1 varchar(10),
Col2 decimal (10,2),
Col3 datetime)
GO
When I type INSERT INTO #T, I am correctly prompted for the temporary table and when selected the following appears:
INSERT INTO #TempTable (
Col1,
Col2,
Col3
) VALUES (
/* Col1 - varchar(50) */ '',
/* Col2 - decimal (10,2) */ 0,
/* Col3 - datetime */ '2008-9-29 20:52:49.555' )
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
Can you please check your syntax. You appear to be referencing a variable called TempTable. The following syntax creates a temporary table:
USE [databasename]
GO
CREATE TABLE #TempTable
(Col1 varchar(10),
Col2 decimal (10,2),
Col3 datetime)
GO
When I type INSERT INTO #T, I am correctly prompted for the temporary table and when selected the following appears:
INSERT INTO #TempTable (
Col1,
Col2,
Col3
) VALUES (
/* Col1 - varchar(50) */ '',
/* Col2 - decimal (10,2) */ 0,
/* Col3 - datetime */ '2008-9-29 20:52:49.555' )
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com