S
sixeight
Unregistered / Unconfirmed
GUEST, unregistred user!
以下两种方法执行都出错
1. declare @a varchar(200)
select @a = 'select * from HHDATA'
execute @a
ERR：
Server Message: Number 2812, Severity 16
Stored procedure 'select * from HHDATA' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
2. declare @a varchar(200)
select @a = 'select * from HHDATA'
execute (@a)
ERR:
Incorrect syntax near '('.
1. declare @a varchar(200)
select @a = 'select * from HHDATA'
execute @a
ERR：
Server Message: Number 2812, Severity 16
Stored procedure 'select * from HHDATA' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
2. declare @a varchar(200)
select @a = 'select * from HHDATA'
execute (@a)
ERR:
Incorrect syntax near '('.