Stored procedure for saving data from an extract data to another table

IF exists (SELECT NAME "

Name = 'sp_123' and type = 'p')

Drop Procedure SP_123

Go

CREATE Procedure SP_123

@ Variable Numeric (8),

With encryption

AS

Declare

Begin

INSERT INTO TABLE1 SELECT A, B from Table2 Where ,,,

end

;