如果向存储过程，传送一sql语句要在存储过程中如何运行呢

[fans88]

Sql = "Select * from a inner jon b on a.u=b.u"

ALTER PROCEDURE abc
@Sql nvarchar(max)
as
set nocount on
begin
return
end

[hongmei85]

ALTER PROCEDURE abc
@Sql nvarchar(max)
as
set nocount on
begin
EXEC @Sql
return
end

[fans88]

会提示
找不到存储过程 'Select * from a inner jon b on a.u=b.u'

。

[rings2000]

正解
[Quote=引用 5 楼 hongmei85 的回复:]
测试ok

SQL code
alter PROCEDURE abc @Sql nvarchar(4000)
as
set nocount on
begin
EXEC(@Sql)
return
end
[/Quote]

[lzp4881]

http://hi.baidu.com/lz0830/blog/item/ac409b3e1874363b70cf6cb8.html

[fans88]

If Exists(Select * From Ele_Document Where Document_ID=@Document_ID And SubTitle_ID<>@Subtitle_ID)
Set @Sq = 'Set Subtitle_ID=@Subtitle_ID'
If @Mark = 1
Begin
Set @Flag = 4
If @Sq <> ''
Set @Sq = @Sq + ',Mark=1'
Else
Set @Sq = 'Set Mark=1'
End
If @Sq <> ''
Begin
Set @Sq = 'Update Ele_Document ' + @Sq + ' Where Document_ID=@Document_ID'
exec @Sq
End



Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]找不到存储过程 'Update Ele_Document Set Subtitle_ID=@Subtitle_ID Where Document_ID=@Document_ID'。

[hongmei85]

测试ok

alter PROCEDURE abc @Sql nvarchar(4000)
as
set nocount on
begin
EXEC(@Sql)
return
end