Question

i 在 sql- Server- 2008 程序中有问题创建的选定语句

我被这样处决了:

CREATE PROCEDURE DoSomething
AS
BEGIN
declare @command nvarchar(500);
set @command = N select * from sometable ;
exec @command;
END

of course the select statement is not this simple I add this procedure to linq class and got this message: enter image description here - if i can t use this method to call this procedure what can i do - or is there anything i can do else

编辑 :

I even tried to run this procedure via ado.net but i got exception: SqlException procedure select * from sometable does not exist

任何替代方式请

Answer 1

基于错误消息, 您似乎存储的 proc 正在返回多个结果集, 或者您正在使用临时表格

看看这些员额

Post 1

Post 2

友情链接