SQLServer Top語(yǔ)句參數(shù)化方法

declare @TopCount int
set @TopCount = 100
select top (@TopCount) * from AdventureWorks.HumanResources.Employee

如果有Like等字句，一定要拼Sql的話，也應(yīng)該使用sp_executesql來(lái)執(zhí)行，示例如下：

declare @TopCount int --定義top 數(shù)量
set @TopCount = 100
declare @Title nvarchar(100) --定義like內(nèi)容
set @Title = '%n%'
declare @SelectSql nvarchar(max)
set @SelectSql = '
select top (@TopCountPar) *
from AdventureWorks.HumanResources.Employee
where Title like @TitlePar' --使用參數(shù)化的top和like

--使用sp_executesql 來(lái)執(zhí)行，可以提高效率
exec sp_executesql @SelectSql,
N'@TopCountPar as int,@TitlePar as nvarchar(100)',
@TopCountPar = @TopCount,@TitlePar = @Title