DECLARE @Customers TABLE

(
      CustomerID,
      FirstName VARCHAR(25), 
      LastName VARCHAR(25), 
      Address VARCHAR(50),
      City VARCHAR(50),
      State CHAR(2),
      Zip VARCHAR(10),
      Age TINYINT

)



INSERT INTO Customers 

(Firstname, Lastname, Address, City, State, Zip, Age)

OUTPUT 

INSERTED.CustomerID, INSERTED.FirstName, INSERTED.LastName,
 INSERTED.Address, INSERTED.City, INSERTED.State, INSERTED.Zip, INSERTED.Age

INTO @Customers

(

CustomerID, FirstName, LastName, 

Address, City, State, Zip, Age

)

VALUES

('Kyle', 'Wilson', '2000 Elm Street', 'New York', 'CA', '45678-3456', 25)