從插入新刪除
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 |
喬治 |