Dynamic select clause in SQL Server from XML

Posted by Rohit on Stack Overflow See other posts from Stack Overflow or by Rohit
Published on 2010-04-20T07:15:10Z Indexed on 2010/04/20 7:43 UTC
Read the original article Hit count: 221

Filed under:
|

I have to query a view and include only those columns which are defined in the XML which comes as a parameter to my SP. Can i include that XML in select clause and extract all columns defined in that XML. Please tell a way to do this.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql-server-2008