Temp Table Suggestions SQL Prompt
mikeanslow
Posts: 1 New member
in SQL Prompt
Hi, when using SQL Prompt I'm finding that when I SELECT INTO a temp table I get suggestions perfectly, although when I create the temp table and INSERT INTO there are no suggestions whatsoever.
Do I have something set-up incorrectly or is this expected behavior?
--- Selecting into a temp table
IF OBJECT_ID('tempdb..#Thisworks') Is Not Null Begin Drop Table #Thisworks END
SELECT 123456 AS Res, 1 AS Ver
INTO #Thisworks
--- Creating and inserting into a temp table
IF OBJECT_ID('tempdb..#Thisdoesnt') Is Not Null Begin Drop Table #Thisdoesnt END
CREATE TABLE #Thisdoesnt
( [Res] [int] NOT NULL,
[Ver] [int] NOT NULL
) WITH (DATA_COMPRESSION = PAGE)
INSERT INTO #Thisdoesnt ([Res], [Ver])
SELECT 123456, 1
Do I have something set-up incorrectly or is this expected behavior?
--- Selecting into a temp table
IF OBJECT_ID('tempdb..#Thisworks') Is Not Null Begin Drop Table #Thisworks END
SELECT 123456 AS Res, 1 AS Ver
INTO #Thisworks
--- Creating and inserting into a temp table
IF OBJECT_ID('tempdb..#Thisdoesnt') Is Not Null Begin Drop Table #Thisdoesnt END
CREATE TABLE #Thisdoesnt
( [Res] [int] NOT NULL,
[Ver] [int] NOT NULL
) WITH (DATA_COMPRESSION = PAGE)
INSERT INTO #Thisdoesnt ([Res], [Ver])
SELECT 123456, 1
Tagged:
Answers
Thanks for your post and sorry that we missed this one.
Can you let us know if you are still having issues on the latest version please? I've left a link to the download below.
ftp://support.red-gate.com/patches/SQLPrompt/18Apr2018/SQLPrompt_9.1.8.4871.exe
I hope this helps.
Richard Lynch.
Redgate Software