Where is the error in variable assignment in sql stored procedure?

Question

SQL Server

CREATE PROCEDURE mysp1

  @m int,
  @w int

AS

DECLARE  @par1 int,  @par2 int;
SET @par1 = select [поле] from [таблица1] WHERE .... ;
SET @par2 = select [поле] from [таблица2] WHERE .... ;

BEGIN

INSERT INTO 
   таблица (поле1, поле2) 
   values ( @par1,   @par2) -- в эту таблицу и эти поля вставка

END
GO

Swears at
Incorrect syntax near the keyword 'select'.
What could be wrong?

Answer 1

You misspelled getting the value of a variable. Pay attention to parentheses
or you can write
select @par1 =[поле] from [таблица1] WHERE .... ;