存储过程如下:
CREATE PROCEDURE sp_test
@ID as int
as
set @spName = (select spName from T_SP where ID = @ID) /*这里得到存储过程名字*/
exec @spName /*这里调用会出错*/
GO
请问应该怎么调用?
...全文
363打赏收藏
在存储过程里调用存储过程的问题?
存储过程如下: CREATE PROCEDURE sp_test @ID as int as set @spName = (select spName from T_SP where ID = @ID) /*这里得到存储过程名字*/ exec @spName /*这里调用会出错*/ GO 请问应该怎么调用?