创建存储过程的一个简单代码

use TS

go

if OBJECT_ID('MYPRO','p') is not null

drop procedure MYPRO

create procedure MYPRO

as

 select * from dbo.HAOYOUFENLEI

 execute dbo.MYPRO

 

 select * from HAOYOUFENLEI

 

 if OBJECT_ID('mypro2','p') is not null

drop procedure mypro2

 create procedure mypro2

 (@FLMC nvarchar(20))

  as

 begin

 insert into dbo.HAOYOUFENLEI (FLMC) values(@FLMC)

 end

 execute mypro2 '损友'