有如下表,要求用 [name] 列的数据替换[cardNo]列的数据
CREATE TABLE [dbo].[people](
[id] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[age] [int] NULL,
[cardNo] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
sql代码如下
UPDATE [testDTS].[dbo].[people]
SET [cardNo] = name