從插入新刪除

DELETE FROM [dbo].[Customers]
WHERE CustomerName = 'Gorge';

INSERT INTO [dbo].[Customers]
       ([CustomerName])
 VALUES ('George')

SELECT * FROM [dbo].[Customers]

結果

顧客 ID 顧客姓名
10001 傑瑞
10003 喬治