//创建存储过程
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'