Sql Experts Help Cheyyandi

[bevarse]

maaku errors anni oka database table lo log avutayi
the error message is saved as xml in a column of data type xml.

ippudu problem yenti ante nenu aa table ni query cheyyali
where clause lo xml contains '' ani cheyyali

online lo chusanu but sarigga work avvadam ledu
already ila query chesina vallu vunnara ?

[LOGON]

where clause lo xml contains endi vayya

[ChampakDas]

eedhi chusava
http://stackoverflow.com/questions/2988122/how-to-query-on-xml-column-in-sql-server-2008

[kranthi111]

where cast(column as xml) like '%search%' try chey idhi i m not sure

[erragulabi]

Cast XML into varchar(max) and try to query..

[GoldHand]

bevarse, ... read about these: getClobVal(); extractvalue() functions.

[bevarse]

[quote name='GoldHand' timestamp='1360272325' post='1303243824']
bevarse, ... read about these: getClobVal(); extractvalue() functions.
[/quote]
idi SQL ye na bhayya ?
yekkado chadivaanu oracle lo aite vere la vuntundi ani

[bevarse]

[quote name='erragulabi' timestamp='1360272261' post='1303243815']
Cast XML into varchar(max) and try to query..
[/quote]
adi chala pedda xml bhayya oka page vuntundi

[dotnetrockz]

[size=2][color=#0000ff][size=2][color=#0000ff][size=2]declare @Xml [/size][size=2][color=#0000ff][size=2][color=#0000ff]text[/color][/size][/color][/size][/color][/size][/color][/size]

[size=2][color=#0000ff][size=2][color=#0000ff]EXEC[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#800000][size=2][color=#800000]sp_xml_preparedocument[/color][/size][/color][/size][size=2][color=#0000ff][size=2][color=#0000ff] [/color][/size][/color][/size][size=2][color=#000000]@Idoc [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]OUTPUT[/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080],[/color][/size][/color][/size][size=2][color=#000000] @Xml[/color][/size]

[size=2][color=#0000ff][size=2][color=#0000ff]set[/color][/size][/color][/size][size=2] @XmlPath [/size][size=2][color=#808080][size=2][color=#808080]=[/color][/size][/color][/size] [size=2][color=#ff0000][size=2][color=#ff0000]'/Info/Data'[/color][/size][/color][/size]

[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff]Insert[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]Into[/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2]@T[/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2]([/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2])[/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff]select[/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2]e_user_name[/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff]from[/color][/size][/color][/size][size=2] [/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff]openxml [/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][size=2]@Idoc[/size][size=2][color=#808080][size=2][color=#808080],[/color][/size][/color][/size][size=2] @XmlPath[/size][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080]with[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080][size=2]e_user_name [/size][size=2][color=#0000ff][size=2][color=#0000ff]VarChar[/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][size=2]50[/size][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size] [size=2][color=#ff0000][size=2][color=#ff0000]'@e_[/color][/size][/color][/size][size=2][color=#ff0000][size=2][color=#ff0000]user_name[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]

[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080][size=2][color=#0000ff][size=2][color=#0000ff]EXEC[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#800000][size=2][color=#800000]sp_xml_removedocument[/color][/size][/color][/size][size=2][color=#0000ff][size=2][color=#0000ff] [/color][/size][/color][/size][size=2][color=#000000]@Idoc[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]

[bevarse]

screen shot tisanu adi ikkada yela paste cheyyali?

[deals2buy]

[quote name='GoldHand' timestamp='1360272325' post='1303243824']
bevarse, ... read about these: getClobVal(); extractvalue() functions.
[/quote]

idi ORACLE lo na bhayya?

[quote name='Nissan' timestamp='1360272754' post='1303243884']
[size=2][color=#0000ff][size=2][color=#0000ff][size=2]declare @Xml [/size][size=2][color=#0000ff][size=2][color=#0000ff]text[/color][/size][/color][/size][/color][/size][/color][/size]

[size=2][color=#0000ff][size=2][color=#0000ff]EXEC[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#800000][size=2][color=#800000]sp_xml_preparedocument[/color][/size][/color][/size][size=2][color=#0000ff][size=2][color=#0000ff] [/color][/size][/color][/size][size=2][color=#000000]@Idoc [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]OUTPUT[/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080],[/color][/size][/color][/size][size=2][color=#000000] @Xml[/color][/size]

[size=2][color=#0000ff][size=2][color=#0000ff]set[/color][/size][/color][/size][size=2] @XmlPath [/size][size=2][color=#808080][size=2][color=#808080]=[/color][/size][/color][/size] [size=2][color=#ff0000][size=2][color=#ff0000]'/Info/Data'[/color][/size][/color][/size]

[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff]Insert[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]Into[/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2]@T[/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2]([/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2])[/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff]select[/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2]e_user_name[/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff]from[/color][/size][/color][/size][size=2] [/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#0000ff]openxml [/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][size=2]@Idoc[/size][size=2][color=#808080][size=2][color=#808080],[/color][/size][/color][/size][size=2] @XmlPath[/size][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080]with[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080][size=2]e_user_name [/size][size=2][color=#0000ff][size=2][color=#0000ff]VarChar[/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080]([/color][/size][/color][/size][size=2]50[/size][size=2][color=#808080][size=2][color=#808080])[/color][/size][/color][/size] [size=2][color=#ff0000][size=2][color=#ff0000][email=""]'@e[/email][/color][/size][/color][/size][size=2][color=#ff0000][size=2][color=#ff0000][email=""]_user_name'[/email][/color][/size][/color][/size][size=2][color=#808080][size=2][color=#808080],[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]
[size=2][color=#ff0000][size=2][color=#ff0000][size=2][color=#0000ff][size=2][color=#0000ff][size=2][color=#808080][size=2][color=#808080][size=2][color=#0000ff][size=2][color=#0000ff]EXEC[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#800000][size=2][color=#800000]sp_xml_removedocument[/color][/size][/color][/size][size=2][color=#0000ff][size=2][color=#0000ff] [/color][/size][/color][/size][size=2][color=#000000]@Idoc[/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size][/color][/size]


[/quote]

[img]http://www.manadb.com/Smileys/default/goodpost.gif[/img] ilaanti oka sp untundani kuda teleedu

[dotnetrockz]

[quote name='Kaarthikeya' timestamp='1360273002' post='1303243914']
idi ORACLE lo na bhayya?



[img]http://www.manadb.com/Smileys/default/goodpost.gif[/img] ilaanti oka sp untundani kuda teleedu
[/quote]
yeah okavela aa xml ni parse cheyyalante
just aa xml lo unna child nodes (columns) ni oka temp table to declare chesi paian ichina format lo insert cheyyadame...

direct xml tho where clause idea ledhu...

[dotnetrockz]

[quote name='bevarse' timestamp='1360272846' post='1303243892']
screen shot tisanu adi ikkada yela paste cheyyali?
[/quote]
upload in tinypic.com and daantlo last url(.jpg extension unedhi) copy chesi ikkada post new meesage lo insert image select cheyyi...paste that url

[deals2buy]

[quote name='Nissan' timestamp='1360273411' post='1303243968']
yeah okavela aa xml ni parse cheyyalante
just aa xml lo unna child nodes (columns) ni oka temp table to declare chesi paian ichina format lo insert cheyyadame...

direct xml tho where clause idea ledhu...
[/quote]
okkk...nuvvu SQL meedane na bhayya pani chesedi?

[powerstar123]

where (XMLColumn as varchar(max)) like '%xxxx%'