Posts
Sort by recent activity
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...
Giving up on SQL Prompt 3 for now
Folks,
I really like the basic premise and idea behind SQL Prompt 3 - to provide database pros with intellisync in Query Analyzer and SQL Server Management Studio.
But I must say, the current versi...
"Count" not recognized as a reserved word
Folks,
I was trying to type a query something like
select count(*) from .....
but when I had typed "count" and wanted to go on, SQL Prompt jumped in and replaced that with "Country", which happens ...
Table aliases
Hmm..... SQL Prompt is trying to be helpful by adding table aliases - but again, it's not very smart discovering that one alias might already be in use....
I started with this query:
select * from ...
Not very smart on typed prefixes in general....
I just noticed SQL Prompt 3 doesn't seem to be very smart about pre-typed prefixes, either....
So I have a query like
select * from dbo.T_Contract as c
and then I go back to specify a few fields fr...
Doesn't detect a "dbo." prefix
Folks,
I like SQL Prompt 3 very much - looks just so much nicer and slicker than before!
However, one thing is bugging me: I often type
select <fields> from dbo.
and then hit Ctrl-Space. Now I can ...