动态查询表

[xiaofeng007]

declare @end_time char(11),@number int,@sql varchar(8000)
set @sql='select @number=min(id) from'+' Submit'+@end_time
exec sp_executesql @sql,N'@number int number output','@number,output'
select @number
go
出现问题：过程需要参数 '@statement' 为 'ntext/nchar/nvarchar' 类型。

[pengdali]

declare @end_time char(11),@number int,@sql nvarchar(4000)
set @sql=N'select @number=min(id) from'+' Submit'+@end_time
exec sp_executesql @sql,N'@number int number output','@number,output'
select @number

[pengdali]

declare @end_time char(11),@number int,@sql nvarchar(4000)
set @sql=N'select @number=min(id) from Submit'+@end_time
exec sp_executesql @sql,N'@number int output',@number output
select @number