哪用的着循环? 一条语句搞定DECLARE @LstName NVARCHAR(100) UPDATE TABLE SET @LstName=LastName,此处可以操作变量
if object_id('[TB]') is not null drop table [TB] create table [TB](ld_P INT,LastName varchar(50),FirstName varchar(50),Address varchar(50),City VARCHAR(50)) insert into [TB] select 1,'1',NULL,NULL,'bvv' union all select 2,'4',NULL,NULL,'bvv' union all select 3,'8',NULL,NULL,'bvv' union all select 4,'12',NULL,NULL,'bvv' union all select 5,'22',NULL,NULL,'222'
GO
DECLARE @str VARCHAR(50) ----------------------开始-------------------- BEGIN TRY BEGIN TRAN DECLARE test CURSOR FOR SELECT LastName FROM dbo.TB OPEN test FETCH NEXT FROM test INTO @str WHILE (@@fetch_status=0) BEGIN PRINT @str --取出LastName给变量 FETCH NEXT FROM test INTO @str END CLOSE test DEALLOCATE test COMMIT TRAN END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK TRAN END CATCH ---------------------结束--------------------
declare @ln varchar(50) declare ap scroll cursor for select LastName from [表名]
open ap fetch first from ap into @ln while(@@fetch_status<>-1) begin [处理过程..] fetch next from ap into @ln endclose ap deallocate ap
楼上的当然可以
另外
ado.net中不是有DataReader吗,既然连得上数据库,你就应该知道有DataReader这个东西,可以循环读取
UPDATE TABLE SET @LstName=LastName,此处可以操作变量
create table [TB](ld_P INT,LastName varchar(50),FirstName varchar(50),Address varchar(50),City VARCHAR(50))
insert into [TB]
select 1,'1',NULL,NULL,'bvv' union all
select 2,'4',NULL,NULL,'bvv' union all
select 3,'8',NULL,NULL,'bvv' union all
select 4,'12',NULL,NULL,'bvv' union all
select 5,'22',NULL,NULL,'222'
GO
DECLARE @str VARCHAR(50)
----------------------开始--------------------
BEGIN TRY
BEGIN TRAN
DECLARE test CURSOR FOR SELECT LastName FROM dbo.TB
OPEN test
FETCH NEXT FROM test INTO @str
WHILE (@@fetch_status=0)
BEGIN
PRINT @str --取出LastName给变量
FETCH NEXT FROM test INTO @str
END
CLOSE test
DEALLOCATE test
COMMIT TRAN
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRAN
END CATCH
---------------------结束--------------------
declare @ln varchar(50)
declare ap scroll cursor for
select LastName from [表名]
open ap
fetch first from ap into @ln
while(@@fetch_status<>-1)
begin [处理过程..] fetch next from ap into @ln
endclose ap
deallocate ap
?????