Better SQLXML Support....
SQL XML is a great tool that gets very little support. When I am on an XML type variable...the intellisense isn't great....AT ALL. Doing something like:
declare @xml XML;
set @xml = '<Tests><Test><Id>1</Id></Test></Tests>';
select @xml.value --This doesn't have intellisense. It will try to capitalize .value to .VALUE which isn't correct.
So better SQL XML support would be nice.
In your example “value” will be suggested and left as lowercase in the latest version of Prompt 6. If you’re still having problems even on the latest version please contact support as you may have hit a bug.