declare @Max int
declare @TableName varchar(280)
declare @ss nvarchar(4000)set @ss=N'select @max= type from '+ @tablenameexec sp_executesql @ss ,N'@max int output',@max outputselect @max
declare @TableName varchar(280)
declare @ss nvarchar(4000)set @ss=N'select @max= type from '+ @tablenameexec sp_executesql @ss ,N'@max int output',@max outputselect @max
declare @TableName varchar(280)
declare @strsql varchar(500)set @strsql = 'select '+@Max=+'max(列名) from '+tablename
exec(@strsql)