tomotoboy
- 浏览: 162518 次
- 性别:
- 来自: 成都
-
最新评论
-
abc08010051：
简单明了，非常不错
java.lang.Thread.State类详解 -
tenderlitch：
jdk api文档里面的描述...
set闲聊 -
xmind：
图不错，收藏之。
图中Thread.wait()改用Objec ...
java.lang.Thread.State类详解 -
lahvey：
因为你的$VALUE值是“sed.txt”，并不是这个文件的内 ...
条件控制（test，expr……） -
tomotoboy：
thanks
tr用法
相关推荐
WHILE @@FETCH_STATUS=0 BEGIN UPDATE t_dishes SET ordered_number = ordered_number + @OrderNum WHERE id = @DishId; --更新数据 FETCH NEXT FROM My_Cursor INTO @DishId, @OrderNum; --读取下一行数据(将 ...
while (@@fetch_status = 0) begin fetch next from @exec_cur into @Id, @UserName, @Address; print 'Id: ' + convert(varchar, @Id) + ', name: ' + @UserName + ', Address: ' + @Address; end close @exec_...
WHILE @@FETCH_STATUS=0 BEGIN set @COUNT = PATINDEX( '%(%', @XM) IF @COUNT > 0 BEGIN SET @YXM = SUBSTRING(@XM,0,@COUNT) UPDATE JCXX SET XM = @YXM WHERE ID =...
-- Check @@FETCH_STATUS to see if there are any more rows to fetch. WHILE @@FETCH_STATUS = 0 BEGIN declare @strtemp varchar(50) -- Concatenate and display the current values in the variables. --...
WHILE @@fetch_status = 0 BEGIN IF @@fetch_status = -2 CONTINUE BEGIN TRANSACTION SET @sqlStr = @sqlStr + CAST(@fields as nvarchar(128)) + ',' IF @@error = 0 BEGIN COMMIT END ELSE ...
pattern_id,nrc_pattern_path from #nrc_pattern_tmp open cur_nrc_pattern fetch cur_nrc_pattern into @pattern_id_tmp, @fname while @@fetch_status = 0 begin --create the data process answer file set @m_...
SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE test @From varchar(100)="zhang.zhanling@itgemini.net" , @To varchar(100)=...WHILE @@FETCH_STATUS = 0 BEGIN SELECT @NUM = @NUM+1
while(@@fetch_status=0) begin exec(@c1) fetch next from c1 into @c1 end close c1 deallocate c1 --删除表 DECLARE c2 cursor for select 'drop table ['+name +']; ' from sysobjects where...
WHILE @@FETCH_STATUS = 0 BEGIN -- Do the showcontig of all indexes of the table INSERT INTO #fraglist EXEC ('DBCC SHOWCONTIG (''' + @tablename + ''') WITH FAST, TABLERESULTS, ALL_INDEXES,...
@xszl_abc int,@xsze_abc int fetch next from abc_cursor into @year_abc, @cph_abc,@cpm_abc ,@xszl_abc,@xsze_abc while @@FETCH_STATUS = 0 begin if(@year_abc in(select 年 from nxsb)and @cph_abc in (select...
declare @max integer,@id integerdeclare cur_rows cursor local for select id,count(*) from 表名 group by id having count(*) > 1open cur_rowsfetch cur_rows into @id,@maxwhile @@fetch_status=0beginselect...
While @@FETCH_STATUS = 0 Begin re: set @DID = 0 set @DID = (Select min(FDetailID) From tmp_Batch Where FNumber = @Number And FSPID = @SPID And FQty <> 0 ) set @BatchNo =(Select FBatchNo From tmp_...
当时自己初学SQL时，对游标很难理解，现在编写了一个实例游标循环，到时写SQL循环时方便些 declare cursor1 cursor for select *from bb --把...while @@fetch_status=0 --返回值成功的时候循环 以上是我个人的理解
WHILE @@fetch_status = 0 BEGIN PRINT @value; --填充下一条数据. FETCH NEXT FROM c_test_main INTO @id, @value; END; -- 关闭游标 CLOSE c_test_main; --释放游标. DEALLOCATE c_test_main; ...
SQL游标函数 @@FETCH_STATUS 返回被 FETCH 语句执行的最后游标的状态，而不是任何当前被连接打开的游标的状态。
WHILE @@FETCH_STATUS =0 BEGIN PRINT '产品编号 产品名称 销售日期 销售数量 销售金额' PRINT @ProNo+' '+@ProName+' '+STR(YEAR(@SaleDate))+'-'+STR(MONTH(@SaleDate)) +'-'+STR(DAY(@SaleDate))+' '+@Quantity+...
方法一 declare @max integer,@id integer ...@max while @@fetch_status=0 begin select @max = @max -1 set rowcount @max delete from 表名 where 主字段 = @id fetch cur_rows into @id,@
while @@fetch_status=0 begin select @max = @max -1 set rowcount @max delete from 表名 where 主字段 = @id fetch cur_rows into @id,@max end close cur_rows set rowcount 0 方法二 有两个意义上的重复记录...
代码如下: declare @i int declare cur cursor for select spid from sysprocesses where db_name(dbid)= ‘Your_Database_Name’ open cur fetch next from cur into @i while @@fetch_status=0 begin