从插入新删除
DELETE FROM [dbo].[Customers]
WHERE CustomerName = 'Gorge';
INSERT INTO [dbo].[Customers]
([CustomerName])
VALUES ('George')
SELECT * FROM [dbo].[Customers]
结果
顾客 ID | 顾客姓名 |
---|---|
10001 |
杰瑞 |
10003 |
乔治 |
DELETE FROM [dbo].[Customers]
WHERE CustomerName = 'Gorge';
INSERT INTO [dbo].[Customers]
([CustomerName])
VALUES ('George')
SELECT * FROM [dbo].[Customers]
顾客 ID | 顾客姓名 |
---|---|
10001 |
杰瑞 |
10003 |
乔治 |