阅读背景:

如何创建一个接受查询字符串并返回查询结果集的UDF

来源:互联网 

I want to create a stored procedure that takes a simple SELECT statement and return the resultset as a CSV string. So the basic idea is get the sql statement from user input, run it using EXEC(@stmt) and convert the resultset to text using cursors. However, as SQLServer doesn't allow:I want to create a stored procedure that takes




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: