1、 创建语法
create proc | procedure pro_name [{@参数数据类型} [=默认值] [output], {@参数数据类型} [=默认值] [output], .... ] as SQL_statements
call procedure pro_name
3、删除
drop procedure pro_name
以下是一个基本的存储过程的代码:
1 CREATE PROCEDURE Get_Data 2 ( 3 @Dealer_ID VARCHAR(50) 4 ) 5 AS 6 SELECT * FROM myDa
开始写了一个存储过程,用来实现数据的插入操作,说白了就是添加数据。这个存储过程的代码如下:
1 CREATE PROCEDURE PROC_INSERT_DATA_ID 2 @DealerID varchar(50) 3 AS 4 BEGIN 5 DECLARE @COUNT INT 6 7 SET @COUNT = (SELECT COUNT(*) FROM myDATA_Details WHERE DealerID = @DealerID) 8 IF (@COUNT>0) 9 BEGIN 10 DELETE FROM myDATA_Details WHERE DealerID = @DealerID 11 INSERT INTO myDATA_Details (DealerID) VALUES (@DealerID) 12 END 13 ELSE 14 BEGIN 15 INSERT INTO myDATA_Details (DealerID) VALUES (@DealerID) 16 END 17 END