日期:2014-05-17 浏览次数:20598 次
UPDATE [TB]
SET [ZD1]='120'+[ZD1]
GO
UPDATE [TB]
SET [ZD2]=CONVERT(VARCHAR(11),GETDATE(),20)+CONVERT(VARCHAR(10),[ZD1],8)
UPDATE [TB]
SET [ZD3]=[ZD1]-[ZD2]
UPDATE [TB] SET [ZD1]='120'+[ZD1],[ZD2]=CONVERT(VARCHAR(11),GETDATE(),20)+CONVERT(VARCHAR(10),[ZD1],8),[ZD3]=[ZD1]-[ZD2]
where [ZD1] IS NOT NULL OR [ZD2] IS NOT NULL OR [ZD3] IS NOT NULL