【MSSql2000】数据连接

drop table #acreate table #a ([iid] [int]IDENTITY (1, 1) NOT NULL ,[aa] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[a_id] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL  )declare @values char(10)declare @values1 char(10)declare @values_b1 char(10)declare @values_b2 varchar(100)declare @values_b3 varchar(100)declare title_cursor1 scroll cursor  --定义一个游标for select * from a    --游标的结果数据集open title_cursor1                             --打开已建立好的游标fetch  from title_cursor1 into @values,@values1                --检索游标中的记录1SET @VALUES_B3=''SET @VALUES_B2=''--insert into #a(aa,a_id)values(@values,@values1)while @@fetch_status=0                        --判断FETCH 语句是否成功begin -----------------------DECLARE TITLE_CURSOR2 SCROLL CURSOR  --定义一个游标FOR SELECT BB FROM B WHERE A_IID=@VALUESOPEN TITLE_CURSOR2FETCH  FROM TITLE_CURSOR2 INTO @VALUES_B1                --检索游标中的记录1WHILE @@FETCH_STATUS=0BEGINSET @VALUES_B3=@VALUES_B3+@VALUES_B1+@VALUES_B2FETCH  FROM TITLE_CURSOR2 INTO @VALUES_B2SET @VALUES_B1=''print @VALUES_B3END----------------- insert into #a(aa,a_id)values(@values1,@VALUES_B3) fetch  from title_cursor1 into @values,@values1          --循环数据集中的所有记录   endclose title_cursor2                      --关闭游标deallocate title_cursor2                 --删除游标引用close title_cursor1                      --关闭游标deallocate title_cursor1                 --删除游标引用goselect * from  #aselect * from a select * from b