SQLServer存储过程的问题
@StockCode nvarchar(50),@days intasselect min(LowestPrice)from(select top (@days) LowestPricefrom Stockswhere StockCode=@StockCodeorder by UpdateTime desc)t
--用动态sql Exec SP_EXECUTESQL @sql语句
[解决办法]
declare @sql varchar(8000)set @sql='select min(LowestPrice)from(select top '+ltrim(@days)+' LowestPricefrom Stockswhere StockCode=@StockCodeorder by UpdateTime desc)t 'exec (@sql)
[解决办法]
--两个变量,都需要从外面传进去declare @sql varchar(8000)set @sql='select min(LowestPrice)from(select top '+ltrim(@days)+' LowestPricefrom Stockswhere StockCode='+@StockCode+' order by UpdateTime desc)t 'exec (@sql)
[解决办法]
declare @sql nvarchar(max)set @sql='select min(LowestPrice)from(select top ('+@days+') LowestPricefrom Stockswhere StockCode='''+@StockCode+'''order by UpdateTime desc)t'
[解决办法]
exec sp_executesql @sql
[解决办法]
@StockCode nvarchar(50),@days intasdeclare @sql varchar(8000)set @sql='select min(LowestPrice)from(select top '+ltrim(@days)+' LowestPricefrom Stockswhere StockCode='''+@StockCode+''' order by UpdateTime desc)t 'exec (@sql)