Posts
Sort by recent activity
(4.0.2.53) - UPDATE... SET... does not show colums hints
Hi,
I got a problem with 4.0.2.53.
When I type
UPDATE T
SET ....
FROM TableName AS T
I do not get any column hints after the SET statement. In 3.9 it worked perfectly. I really miss that feature.
INSERT INTO #TempTable shows columns in strange order
Hi there,
when I type the following statements SQL-Prompt inserts the Columns in the INSERT INTO Statement not in the correct (given) order. :shock:
CREATE TABLE #Test (_OID INT PRIMARY KEY, Test ...
TEXTPTR is used to script varbinary(max) data
I was wondering why the SQL Data Compare still uses the "old" functionality of the TEXTPTR to script binary data.
Will it be changed to the UPDATE .... .WRITE statement?
Regards,
Thorsten
Snippets - SPACES instead of TAB
Hi there,
when candidates are inserted by SQL-Prompt it uses TAB and not single SPACEs to intent the candidates. Is there any way to force SQL-Prompt to use SPACE and not TAB???
Thanks,
Thorsten
SQL-Script - automatically add GO every xx lines
Hi,
I have a very large table to compare between databases. Sometimes there are 800,000 rows to insert in the new database.
When I script the 800,000 rows they are in one batch.
Is there any way to...
Where can I get SQLPrompt 3.7
Hi there,
where can I get SQL-Prompt 3.7?
And what are the differences between 3.7 and 3.6?
Thanks...