Proc 1:
create proc test as
create table #t(ban varchar(10),l1 varchar(10),l2 varchar(10),l3 varchar(10),l4 varchar(10),la varchar(10),ls varchar(10))
insert into #t values('1','1','1','1','1','1','1')
select * from #t
drop table #t --要把临时表删除
go
asp: oCmd.CommandText = "test" --改成test
Set RecSet = oCmd.Excute
do while not Response.eof
Response.Write RecSet(0)
Response.movenext
loop
create proc test as
create table #t(ban varchar(10),l1 varchar(10),l2 varchar(10),l3 varchar(10),l4 varchar(10),la varchar(10),ls varchar(10))
insert into #t values('1','1','1','1','1','1','1')
select * from #t
drop table #t --要把临时表删除
go
asp: oCmd.CommandText = "test" --改成test
Set RecSet = oCmd.Excute
do while not Response.eof
Response.Write RecSet(0)
Response.movenext
loop
asp:
oCmd.CommandText = "test" --改成test
Set RecSet = oCmd.Excute
if not RecSet.eof then
do while not Response.eof
Response.Write RecSet(0)
Response.movenext
loop
end if
Proc 1:
create proc test as
set nocount on
create table #t(ban varchar(10),l1 varchar(10),l2 varchar(10),l3 varchar(10),l4 varchar(10),la varchar(10),ls varchar(10))
insert into #t values('1','1','1','1','1','1','1')
select * from #t
drop table #t
set nocount off
go
http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=133244