1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
| DROP TABLE IF EXISTS dbo.MyTable;
CREATE TABLE dbo.MyTable (
[id] INT IDENTITY NOT NULL PRIMARY KEY,
[Name] VARCHAR(50) NOT NULL,
[Address] VARCHAR(100) NOT NULL,
PhoneNo VARCHAR(10) NOT NULL
);
DECLARE @OutputTbl TABLE (
[id] INT NOT NULL,
[Name] VARCHAR(50) NOT NULL,
[Address] VARCHAR(100) NOT NULL,
PhoneNo VARCHAR(10) NOT NULL
);
INSERT INTO dbo.MyTable ([Name], [Address], [PhoneNo])
OUTPUT INSERTED.id, INSERTED.[Name], INSERTED.[Address], INSERTED.[PhoneNo]
INTO @OutputTbl([id], [Name], [Address], [PhoneNo])
VALUES ('James', 'Adresse 1', '0102030405'),
('David', 'Adresse 2', '0203040506'),
('Steven', 'Adresse 3', '0304050607');
SELECT * FROM @OutputTbl;
SELECT SCOPE_IDENTITY();
GO
DECLARE @OutputTbl TABLE (
[id] INT NOT NULL,
[Name] VARCHAR(50) NOT NULL,
[Address] VARCHAR(100) NOT NULL,
PhoneNo VARCHAR(10) NOT NULL
);
INSERT INTO dbo.MyTable ([Name], [Address], [PhoneNo])
OUTPUT INSERTED.id, INSERTED.[Name], INSERTED.[Address], INSERTED.[PhoneNo]
INTO @OutputTbl([id], [Name], [Address], [PhoneNo])
VALUES ('Toto', 'Adresse 4', '0102030405');
SELECT * FROM @OutputTbl;
SELECT SCOPE_IDENTITY();
GO |
Partager