数据库操作（七）存储过程

//创建存储过程

alter procedure zmt_firstpro

@condition nvarchar(1000)

as

begin

--set nocount on

declare @strsql nvarchar(1000)

set @strsql = 'select username from TrainStudents '+@condition

print(@strsql)

exec(@strsql)

end

exec zmt_firstpro  ' where age >8'

--//创建临时表1

alter procedure zmt_firstpro

as

begin

set nocount on

select * into #zmt_student from TrainStudents

select * from #zmt_student

drop table #zmt_student

end

exec zmt_firstpro

//创建临时表2

alter procedure zmt_firstpro

as

begin

set nocount on

create table #zmt_student(id int)

insert into #zmt_student

select id from TrainStudents

select * from #zmt_student

drop table #zmt_student

end

exec zmt_firstpro

//创建临时表3

alter procedure zmt_firstpro

@condition nvarchar(1000)

as

begin

set nocount on

declare @strsql nvarchar(1000)

create table #zmt_student(id int)

set @strsql = 'insert into #zmt_student'+@condition+' from TrainStudents '

print(@strsql)

exec(@strsql)

select * from #zmt_student

drop table #zmt_student

end

exec zmt_firstpro ' select id'