CREATE PROCEDURE GL_YHROCE ( @chrWhere varchar(1000) ) AS Declare @YHSQL varchar(2000) If exists(select name from tempdb..sysobjects where name ='GL_YH') Drop table tempdb..GL_YH set @YHSQL='select * into tempdb..GL_YH from ufdata_888_2004..gl_accsum' if ltrim(rtrim(@chrWhere)) <> '' set @YHSQL = @YHSQL + 'where ' + @chrWhere exec(@YHSQL ) exec GL_YHROCE '' select * from tempdb..GL_YH exec GL_YHROCE @YHSQL exec @YHSQL为什么执行下面提示错误 with procedure GL_YHROCE tempdb..GL_YH哎!
(
@chrWhere varchar(1000)
)
AS
Declare @YHSQL varchar(2000)
If exists(select name from tempdb..sysobjects where name ='GL_YH')
Drop table tempdb..GL_YH
set @YHSQL='select * into tempdb..GL_YH
from ufdata_888_2004..gl_accsum'
if ltrim(rtrim(@chrWhere)) <> '' set @YHSQL = @YHSQL + 'where ' + @chrWhere
exec(@YHSQL )
exec GL_YHROCE '' select * from tempdb..GL_YH
exec GL_YHROCE @YHSQL
exec @YHSQL为什么执行下面提示错误
with procedure GL_YHROCE tempdb..GL_YH哎!