/*去除凭证外部凭证标记*/
SELECT
*
FROM GL_accvouch
WHERE iYPeriod IN ('202007','202008','202009' )
BEGIN TRANSACTION
UPDATE GL_accvouch SET coutsysname=NULL WHERE iYPeriod IN ( '202007', '202008', '202009' )
AND coutsysname IS NOT NULL
COMMIT TRANSACTION
————————————————
版权声明：本文为CSDN博主「haichao118」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/haichao118/article/details/119902804