INSERT INTO .... shows VALUES()
TSchwab
Posts: 80
In 3.9 SQL-Prompt did not insert the VALUES () if I had a SELECT .... following the INSERT INTO...
Any chance to get this behaviour in 4.0 (or would it be possible to get the INSERT INTO ...columns without VALUES())???
Thanks,
Regards,
Thorsten
Any chance to get this behaviour in 4.0 (or would it be possible to get the INSERT INTO ...columns without VALUES())???
Thanks,
Regards,
Thorsten
Regards,
Thorsten
Thorsten
Comments
Can you kindly let us what settings allowed you to get the output:
INSERT INTO ...columns without VALUES() in 3.9?
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
I think I had it at the same setting than in 4.0.
You can reproduce the behaviour if you try this:
First type the SELECT statement... like...
SELECT ColumnName
FROM table1
then, place the cursor on the row above the SELECT statement and type ii (TAB) to get INSERT INTO and then choose any table and press TAB again and you will only get the INSERT INTO TableName (Column1, Colum2, etc...)
with out the VALUES(....)
That was a great feature and that one is missing... I don't need the VALUES....
Any chance to get it "repaired" very soon?
Thanks.
Regards,
Thorsten
Thorsten
Thorsten
Thorsten