DECLARE @StrSQL nvarchar(1000)
set @num=10
SET @StrSQL = 'SELECT TOP ' + CAST(@TopProductNum as varchar(20)) + '
*
FROM
product_info'EXEC sp_executesql @StrSQL
-------------------------------------------------------------------------------
set @num=10
SET ROWCOUNT @numselect * from product
set rowcount 0
set @num=10
SET @StrSQL = 'SELECT TOP ' + CAST(@TopProductNum as varchar(20)) + '
*
FROM
product_info'EXEC sp_executesql @StrSQL
-------------------------------------------------------------------------------
set @num=10
SET ROWCOUNT @numselect * from product
set rowcount 0
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货