sybase存储过程实例

IF OBJECT_ID('dbo.gcdr_prepare_markit_levels') IS NOT NULL
BEGIN
    DROP PROCEDURE dbo.gcdr_prepare_markit_levels
    IF OBJECT_ID('dbo.gcdr_prepare_markit_levels') IS NOT NULL
        PRINT '<<< FAILED DROPPING PROCEDURE dbo.gcdr_prepare_markit_levels >>>'
    ELSE
        PRINT '<<< DROPPED PROCEDURE dbo.gcdr_prepare_markit_levels >>>'
END
go


create proc dbo.gcdr_prepare_markit_levels
(
    @id int,
    @name varchar(20)
)
as

if OBJECT_ID('dbo.student') is not null
begin
    drop table student
end

create table #student
(id int,
name varchar(20))

insert into #student values (1,'22')
insert into #student values (2,'22')
insert into #student values (3,'22')
insert into #student values (4,'22')
insert into #student values (5,@name)

select * from #student

drop table #student

go

exec gcdr_prepare_markit_levels null,'lili'