从一个表取数据存到另一个表的数据的存储过程

IF EXISTS( SELECT name FROM sysobjects WHERE
           name = 'sp_123' AND type = 'P')
   DROP PROCEDURE sp_123
GO
CREATE PROCEDURE sp_123
  @变量       Numeric(8), 
  WITH ENCRYPTION
AS
DECLARE
begin
insert into table1 select a,b from table2 where ,,,,;
end
;