62,046
社区成员
发帖
与我相关
我的任务
分享
Declare @Id int
Declare @Name varchar(10)
DECLARE TabA CURSOR FOR
SELECT aid, aname
FROM AA
Open TabA
Fetch Next From TabA into @Id,@Name
while(@@FETCH_STATUS=0)
begin
insert into BB values(@Id,@Name)
Fetch Next From TabA into @Id,@Name
end
Close TabA
DEALLOCATE TabA
DECLARE @CityName NVARCHAR(100)
DECLARE table_cur CURSOR FOR
SELECT top 10 CityName FROM City
OPEN table_cur
FETCH NEXT FROM table_cur INTO @CityName
WHILE( @@fetch_status = 0)
BEGIN
PRINT @CityName
FETCH NEXT FROM table_cur INTO @CityName
END
DEALLOCATE table_cur
Delcare @name varchar(50)
Declare MyCursor Cursor for
select Aname from A
Open MyCursor
FETCH NEXT FROM Aname into @name
WHILE @@FETCH_STATUS = 0
BEGIN
insert into B(BName) values(@name)
FETCH NEXT FROM MyCursor into @name
END
CLOSE MyCursor
DEALLOCATE MyCursor
Declare @Id int
Declare @Name varchar(10)
DECLARE TabA CURSOR FOR
SELECT aid, aname
FROM AA
Open TabA
Fetch Next From TabA into @Id,@Name
while(@@FETCH_STATUS=0)
begin
insert into BB values(@Id,@Name)
Fetch Next From TabA into @Id,@Name
end
Close TabA
insert into B (Bid,Bname)
select Aid,Aname from A