参数化查询示例代码
Declare @ParmDefinition NVARCHAR(500);
Set @ParmDefinition=N' @StoreID INT ,
@StartDate DATETIME ,
@EndDate DATETIME,@SalesID INT'
Exec sp_executesql @strSQL, @ParmDefinition, @StoreID=@StoreID,
@StartDate=@StartDate, @EndDate=@EndDate,@SalesID=@SalesID