有没有一种方法可以从中更新表中的所有列?
像这样吗?
2010-12-31 23:59:59.000
to
2010-12-31 00:00:00.000
像这样吗?
UPDATE t1
SET [Posting Date] = [Posting Date] with ms = 00:00:00.000
WHERE ms = other than 00:00:00.000
GO