Sql
来源:互联网 发布:直销软件系统开发 编辑:程序博客网 时间:2024/05/13 06:47
create procedure dbo.communityAndWish
as
set nocount on
declare @param1 varchar(20),@param2 varchar(20),@index int
set @index = 1
create table #temptb1(
ecardId int ,
spaceName varchar(50)
)
declare cur1 cursor for select ecardId from ecard
declare cur2 cursor for select spaceName from community
open cur1
open cur2
fetch cur2 into @param2
fetch cur1 into @param1
while @@FETCH_STATUS=0
begin
insert into #temptb1(ecardId,spaceName) values(@param1,@param2)
fetch next from cur1 into @param1
fetch next from cur2 into @param2
end
close cur1
close cur2
deallocate cur1
deallocate cur2
select * from #temptb1
drop table #temptb1
go
execute dbo.communityAndWish
drop procedure communityAndWish
as
set nocount on
declare @param1 varchar(20),@param2 varchar(20),@index int
set @index = 1
create table #temptb1(
ecardId int ,
spaceName varchar(50)
)
declare cur1 cursor for select ecardId from ecard
declare cur2 cursor for select spaceName from community
open cur1
open cur2
fetch cur2 into @param2
fetch cur1 into @param1
while @@FETCH_STATUS=0
begin
insert into #temptb1(ecardId,spaceName) values(@param1,@param2)
fetch next from cur1 into @param1
fetch next from cur2 into @param2
end
close cur1
close cur2
deallocate cur1
deallocate cur2
select * from #temptb1
drop table #temptb1
go
execute dbo.communityAndWish
drop procedure communityAndWish
- SQL
- SQL
- SQL
- sql
- sql
- SQL
- sql
- SQL (-)
- sql
- SQL
- SQL
- SQL
- sql
- sql
- sql
- sql
- SQL
- sql
- 安家了
- What is i'm? Chat for charity initiative officially launched!
- 《天风文章》V1.1.0 新闻/文章类asp.net2.0站点系统源码
- Asp.Net 2.0中ObjectDataSource+Formview实现添加,修改
- c++中函数指针的使用方法
- Sql
- 事务保存点
- GNUMake点滴(4)
- Windows Communication Foundation入门(Part One)
- 异步IO、APC、IO完成端口、线程池与高性能服务器
- 在Xp home上安装Rose2003
- 一个女程序员的创业人生:胆识也是一种能力
- 到处都有Blog,这里也来看看
- 20070201~20070308回顾