SQL 2005 Tips Bulk data transfer sample
来源:互联网 发布:手机号码改号软件 编辑:程序博客网 时间:2024/06/05 04:38
CREATE PROC [dbo].[UP_EC_JOB_UpdateAddressType]
(
@Count INT
)
AS
BEGIN
SET NOCOUNT ON
DECLARE @TransactionNumber INT
DECLARE @Cursor CURSOR
SET @Cursor = CURSOR LOCAL STATIC FORWARD_ONLY READ_ONLY
FOR
SELECT TOP(@Count) TransactionNumber
FROM dbo.CustomerShippingInfo WITH(NOLOCK)
WHERE AddressType IS NULL
OPEN @Cursor
FETCH NEXT FROM @Cursor INTO @TransactionNumber
WHILE (@@FETCH_STATUS = 0)
BEGIN
UPDATE dbo.CustomerShippingInfo
SET AddressType = 1
WHERE TransactionNumber = @TransactionNumber
FETCH NEXT FROM @Cursor INTO @TransactionNumber
END
CLOSE @Cursor
DEALLOCATE @Cursor
END
- SQL 2005 Tips Bulk data transfer sample
- Bulk Transfer
- Bulk Insert Sample
- Data Transfer
- Bulk SQL
- SQL 2005 tips --Pivot
- 批量SQL(BULK SQL)
- sql server 2005 T-SQL BULK INSERT (Transact-SQL)
- Data Transfer - Data Import develop
- Data Augmentation & data Transfer Learning
- Data Transfer Object
- Data Transfer Object (DTO)
- ebayUpdate data transfer
- Transfer data by intent
- Transfer data between Activitys
- SQL Server Tips ----- EFFICIENTLY MANAGE LARGE DATA MODIFICATIONS
- 20-TCP Bulk Data Flow
- SQL BULK INSERT
- jQuery validate 分组验证
- 在Java中利用动态代理实现数据库连接与事务的自动管理
- 读取与写入XML文件
- Sql Server 等待状态说明
- 链式栈
- SQL 2005 Tips Bulk data transfer sample
- 移动硬盘引导启动制作
- DOS常见命令
- Sql2005 tips 按照某些条件(一个or多个)分组,取分组中满足某个条件的一条记录
- 计算机常见词汇缩写和词组
- Facebook的成功秘诀是什么 - SNS之我见(一)
- 一段有用的宏
- 荷兰国旗问题
- cross compile busybox for android