DECLARE @str NVARCHAR(200)
DECLARE @Paths NVARCHAR(200)
DECLARE @Length INT
Declare @ID NVARCHAR(128)
Declare iCursor Cursor FOR --创建游标
SELECT ID,Path FROM dbo.Attachments
Open iCursor --打开游标
FETCH Next from iCursor Into @ID, @Paths--用来对每一行来进行循环操作
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @Length=LEN((RTRIM(@Paths))) --求该字段长度
SELECT @str='E'+SUBSTRING(@Paths,2,@Length-1) --截串,字符串拼接
UPDATE dbo.Attachments SET Path=@str WHERE ID= @ID
--此处对每一行要进行的操作的代码
Fetch Next from iCursor into @ID, @Paths
END
CLOSE iCursor --关闭游标
DEALLOCATE iCursor
目标 Path 字段 批量 更改 将 D盘修改为E盘
结果