Posts
Sort by recent activity
Why is there no fullscreen mode for the compare definition
Hi,
I try to compare 2 very large Databases with a lot of tables and the window to select the table and views is very small, and I can not read the full table or comparison key name. Even the colum...
(XML) value statement is autom. converted to uppercase!
When I use an XML variable and try to create a SELECT like this:SELECT T.C.value('@Test', 'INT') as Test
FROM @XML.nodes('V') T(C)
is changed to this:
SELECT T.C.VALUE...
Still no Variable hint in SQL-Prompt v4.0.3
Hi there,
I just installed the new SQL-Prompt v4.0.3 patch....
most of the problems where removed and it works perfectly except
that I don't get a variable hint after about 200 lines...
So, I guess...
INSERT INTO .... shows VALUES()
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...
(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...