DECLARE abc CURSOR FOR
SELECT code
FROM tableA
OPEN abc
GO
FETCH NEXT FROM abc
GO
UPDATE tableA SET code = ?????????????
WHERE CURRENT OF abc
GO
CLOSE abc
DEALLOCATE abc
GO
谢谢!
...全文
3857打赏收藏
请问如何使某个字段的所有值后面都加上一个星号 * ?
这个字段类型为VARCHAR长度18。不知道下面的语句行不行,?哪里不会写。 DECLARE abc CURSOR FOR SELECT code FROM tableA OPEN abc GO FETCH NEXT FROM abc GO UPDATE tableA SET code = ????????????? WHERE CURRENT OF abc GO CLOSE abc DEALLOCATE abc GO 谢谢!