Wednesday, December 7, 2011

Create XML in Store procedure

Ex :
Select Column1,
    Column2,
    Column3
from Table
where Column1 = '5'
for xml path('video'), ROOT('videoPaths')

No comments:

Post a Comment