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 '损友'