sqlserver 脚本 多条记录遍历
临时表方式实现多条记录遍历
declare @oper_cart_item_id bigint; declare @oper_cart_id bigint; declare @the_last_changed_date datetime; declare @oper_cust_id int; select * , 0 as flag into #shoppingcart_temp from deleted; while exists (select top 1 1 from #shoppingcart_temp t where t.flag = 0 ) begin select top 1 @oper_cart_item_id = cart_item_id,@oper_cart_id = cart_id, @oper_cust_id = cust_id,@the_last_changed_date = last_changed_date from #shoppingcart_temp where flag = 0 ; if @oper_cart_item_id is not null and @oper_cart_item_id <> 0 and left(@oper_cart_id,1) = ‘8‘ begin exec proc_sqlser_insertqueue @oper_cart_id,@oper_cart_item_id, @the_last_changed_date, @oper_cust_id, ‘3‘; end update #shoppingcart_temp set flag = 1 where cart_item_id = @oper_cart_item_id end
游标方式实现多条记录遍历
declare @oper_cart_item_id bigint; declare @oper_cart_id bigint; declare @the_last_changed_date datetime; declare @oper_cust_id int; declare shoppingcart_cursor cursor for select cart_item_id,cart_id,cust_id,last_changed_date from deleted; open shoppingcart_cursor fetch next from shoppingcart_cursor into @oper_cart_item_id,@oper_cart_id, @oper_cust_id,@the_last_changed_date while (@@fetch_status=0) begin if @oper_cart_item_id is not null and @oper_cart_item_id <> 0 and left(@oper_cart_id,1) = ‘8‘ begin exec proc_sqlser_insertqueue @oper_cart_id,@oper_cart_item_id, @the_last_changed_date, @oper_cust_id, ‘3‘; end fetch next from shoppingcart_cursor into @oper_cart_item_id,@oper_cart_id, @oper_cust_id,@the_last_changed_date end close shoppingcart_cursor DEALLOCATE shoppingcart_cursor
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。