Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT col1
- FROM table1
- WHERE col2 = 'x'
- ORDER by col3
- FOR XML path('')
- XML_F52E2B61-18A1-11d1-B105-00805F49916B
- ----------------------------------------
- <col1>Foo</col1><col1>Bar</col1>
- select(
- SELECT col1
- FROM table1
- WHERE col2 = 'x'
- ORDER by col3
- FOR XML path('')
- ) as myName
Add Comment
Please, Sign In to add comment