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