22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE dbo.ProductSeo
(
id int NOT NULL IDENTITY (1, 1),
Productname varchar(50) NULL,
news varchar(50) NULL
) ON [PRIMARY]
GO
INSERT INTO [dbo].[ProductSeo]
([Productname],[news])
VALUES
('pcd1','seotitle'),
('pcd1','seotitle'),
('pcd1','seotitle'),
('pcd1','seotitle'),
('pcd1','seotitle'),
('pcd1','seotitle'),
('pcd1','seotitle'),
('pcd1','seotitle'),
('pcd1','seotitle'),
('pcd2','seotitle'),
('pcd3','seotitle'),
('pcd3','seotitle'),
('pcd2','seotitle'),
('pcd4','seotitle'),
('pcd5','seotitle')
GO
CREATE TABLE dbo.new
(
Productname_old varchar(50) NULL,
Productname_new varchar(50) NULL
) ON [PRIMARY]
GO
INSERT INTO [testss].[dbo].[new]
([Productname_old]
,[Productname_new])
VALUES
('pcd1','pxd1'),
('pcd2','pxd2'),
('pcd3','pxd3'),
('pcd4','pxd4'),
('pcd5','pxd5')
GO