create proc pro_allforaccount @database nvarchar(255) as declare @sql varchar(max)set @sql = 'select fparentid,faccountid,fnumber,fname,flevel,fdetail from' +@database+ '.dbo.t_account where fnumber like ''5001%'' AND FDETAIL=TRUE order by flevel,fnumber asc' exec(@sql) drop proc pro_allforaccount建议你PRINT(@SQL)看看
ALTER proc pro_allforaccount @database nvarchar(255) as declare @sql varchar(max)set @sql = 'select fparentid,faccountid,fnumber,fname,flevel,fdetail from ' +QUOTENAME(@database)+ '.dbo.t_account where fnumber like ''5001%'' AND FDETAIL=TRUE order by flevel,fnumber asc' exec(@sql) drop proc pro_allforaccount
@database nvarchar(255)
as declare @sql varchar(max)set @sql = 'select fparentid,faccountid,fnumber,fname,flevel,fdetail from' +@database+ '.dbo.t_account where fnumber like ''5001%'' AND FDETAIL=TRUE order by flevel,fnumber asc'
exec(@sql)
drop proc pro_allforaccount建议你PRINT(@SQL)看看
@database nvarchar(255) as
declare @sql varchar(max)set @sql = 'select fparentid,faccountid,fnumber,fname,flevel,fdetail from ' +QUOTENAME(@database)+ '.dbo.t_account where fnumber like ''5001%'' AND FDETAIL=TRUE order by flevel,fnumber asc'
exec(@sql)
drop proc pro_allforaccount
关键字 'proc' 附近有语法错误。
消息 137,级别 15,状态 2,第 7 行
必须声明标量变量 "@database"。