>Thank for answer Naomi.
>
>Only one question.
>
>IS this two codes has 1 execution plan:
>
>

> 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
>

>
>and
>
>

> 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
>

>
>?

AFAIK they should have the same execution plan, I can run the tests later tonight.

Do you have an access to SSMS - can you test the execution plan?