This is an error in MS-SQL.

Question

I would like to know if the following error is in our installation or an error in MS-SQL:

If we run a specific repository with three parameters, it will take about 3 minutes.

CREATE PROCEDURE [dbo].[ourProcedure] 
    @param1     int,
    @param2     int,
    @param3     dateTime
AS
BEGIN...

If we run the same procedure, but in the creation we created local copies of the parameters, and it takes only 11 seconds!

CREATE PROCEDURE [dbo].[ourProcedure] 
    @param1_x   int,
    @param2_x   int,
    @param3_x   dateTime
AS
BEGIN

DECLARE @param1 int
DECLARE @param2 int
DECLARE @param3 dateTime

@param1 = @param1_x
@param2 = @param2_x
@param3 = @param3_x
...

Can someone tell me WHY? Why doesn't SQL process parameters like C #?

Answer 1

, "snuffing ". , SQL Server , , . . , , , . , , , .

, , , . , , , .

, , , , .