SQL 批理追加修改text字段
摘要：
DECLARE @ID INTDECLARE UTEXT_CURSOR CURSOR FORSELECT ID FROM DBO.UPDATE_TEXT_TEST OPEN UTEXT_CURSORFETCH NEXT FROM UTEXT_CURSOR INTO @IDWHILE @@FETCH_STATUS = 0 BEGIN DECLARE @PTRVAL BINARY(16) --定义指针 SELECT @PTRVAL = TEXTPTR([TEXT]) FROM UPDATE_TEXT_TEST WHERE ID = @ID ... 阅读全文
posted @ 2013-05-15 14:24 Billt_chen 阅读(401) 评论(0) 推荐(0)
浙公网安备 33010602011771号