Posts
Sort by recent activity
Feature request: show your support for XML functions.
Folks, this is extremely disappointing - since V3 Beta, I've been trying to explain that SQL Prompt MUST NOT capitalize the XML XQuery function names as provided by SQL Server - and it still does.....
SQL Prompt 5 **STILL** not getting *it* with XML functions..
Folks, this is disappointing - since about V2 or V3, I've been trying to explain that SQL Prompt *CANNOT* capitalize the XML XQuery function names as provided by SQL Server - and it still does....
...
SQL Data Compare 8.1 keeps crashing
Folks,
after auto-upgrading from SQL Data Compare 8.0.2 to 8.1 today, I cannot launch the app anymore. It keeps crashing right at startup.
Anything I can look up for you to help you diagnose the pr...
INSERT expansion should not add certain fields
Folks,
I really enjoy the SQL Prompt INSERT statement expansion - very useful.
HOWEVER: for two types of fields, I think those should be omitted from the list of fields (IDENTITY fields are already...
Installation doesn't seem to remember installation location
I just installed SQL Prompt 4 on my Windows 7 Enterprise (64-bit) machine. Worked flawlessly.
I usually install stuff in my own directory structure, so I put SQL Prompt into "C:\bin\SQLPrompt".
As ...
SQL Prompt 4 - *STILL* doesn't "get it" when it comes to XML
I'm a bit annoyed - SQL Prompt 4 STILL doesn't "get it" when it comes to SQL XML DML support......
Imagine a table something like this:CREATE TABLE MyDemoTable
(ID INT IDENTITY(1,1) PR...
INSERT INTO...... gets confused
I tried to create a INSERT INTO statement which gets its data from another data (partially).
I started typing INSERT INTO T_Transl.... and then picked the T_Translation table - worked fine, showed ...
Exception when trying to update XML column in table
Folks,
In SQL Server Management Studio 2008 (SP1) I started typing the following UPDATE statement:
UPDATE T_Entry
SET EntryData.modify
EntryData is an XML column. When I typed the opening bracket (...
SQL Prompt STILL doesn't respect SQL XML DML statements
Folks,
Even now, in SQL Prompt 3.9, I am *STILL* getting into trouble since SQL Prompt attempts to UPPERCASE some keywords in my SQL XML DML statements which have to be lowercase by definition.
E.g...
SQL Prompt doesn't respect SQL XML DML statements
I use the XML fields in SQL Server 2005 and every now and then I need to use the XML DML statement to modify the XML fields directly.
When trying to enter a statement like:
UPDATE dbo.T_Entry
SET E...