honza.mf (5/20/2010)
malleswarareddy_m (5/20/2010)
Hi,after for xml i executed but it opened on SSMS.But i saved it in the form XML.With IE i am unable to open.With for xml it shows in different.Please explain in detail abot this characters.but i understand that this char will return the value of the character.suppose char(65) will return A.but and also 32 is space i think.what are the charcters below 32.
The characters below 32 are control characters. Once upon a time they were used to control devices like terminals or printers. Today only some are used regularly (tab, new line, line feed, esc...), others are used for special purposes.
Special position is the very first character char(0): it's typically used as a string terminator in C family languages and many other environments. Always take great care using this special one char.
There is at least one other control character: it's backspace (char (127)).
WITH XML clause is used to turn standard query output in form of XML. It has several forms - see books online.
Thanks for reply.I know that there are different types out put for xml.
Includes For Xml 1)path 2)auto 3)raw 4)explicit.
But when i saved this output and opened with IE it shows some error.Even though it will open in ssms.I am using IE which is Old version 6.0.Is this error is due to IE.please explain in brief.I will open xml without error if we put like this
select * from #t for xml AUTO,ROOT
Malleswarareddy
I.T.Analyst
MCITP(70-451)