I just waana know whether we can use "FOR statement" in Stored Procedures. If yes, can you describe it with some examples of how they are used in stored procedures ?
If you are referring to [ FOR XML ], the answer is yes.
For examples, refer to Books Online, Topics:
'FOR clause'
'FOR XML clause'
|||Do you mean to covert the sp returned resultset into XML?
Inside SP you can use the FOR XML clause on your select statement.
There is a workaround available to convert the SP resultset into XML.
Do you mean to use the For iterator statement?
SQL Server doesn't have For Iterator, you have to use While Iterator
No comments:
Post a Comment