DECLARE @Col2 SMALLINT, @Col1 INT
 DECLARE @SQL NVARCHAR(1000)
 SELECT @SQL = 'select * from dbo.test
 where Col2 = @InnerCol2 and Col1 = @InnerCol1'
 DECLARE @ParmDefinition NVARCHAR(500)
 SET @ParmDefinition = N'@InnerCol2 smallint ,@InnerCol1 int'  

 --change param values and run the same query
  SELECT @Col2 = 2,@Col1 = 3
  EXEC SP_EXECUTESQL  @SQL,@ParmDefinition,
              @InnerCol2  = @Col2,
              @InnerCol1  = @Col1

 DECLARE @Col2 SMALLINT, @Col1 INT
 DECLARE @SQL NVARCHAR(1000)
 SELECT @SQL = 'select * from dbo.test
 where Col2 = @InnerCol2 and Col1 = @InnerCol1'
 DECLARE @ParmDefinition NVARCHAR(500)
 SET @ParmDefinition = N'@InnerCol2 smallint ,@InnerCol1 int'  

 --change param values and run the same query
  EXEC SP_EXECUTESQL  @SQL,@ParmDefinition,
              @InnerCol2  = 4,
              @InnerCol1  = 5