存储过程

一丶

1.利用begin try--end try 、begin catch--end catch来处理是否回滚

begin transaction
 begin try
     SQL语句1
     SQL语句2
    commit transaction
 end try
 begin catch
    rollback transaction
 end catch

 2.判断是否存在存储过程

if (exists (select * from sys.objects where name = '存储过程名'))
  drop proc 存储过程名

 3.

CREATE PROCEDURE 存储过程名称(
    @id VARCHAR(50)
)
AS
BEGIN
    IF @id='567'
    BEGIN
        SELECT * FROM Student WHERE id=@id
    END
    ELSE
    BEGIN
        SELECT * FROM Student
    END
END