Add customer records to two tables simultaneously.

Create Procedure AddCustomerRecord

(@FirstName varchar(20),

@LastName varchar(40),

@Address varchar(150),

@City varchar(45),

@StateorProvince char(2)

@PostalCode varchar(10),

@PhoneNumber varchar(10),

@Year smallint,

@Make varchar(30),

@Model varchar(30),

@Color varchar(30),

@LicensePlate# varchar(10))

As

DECLARE @CustID int

--insert a new customer row

INSERT INTO Customer

(FirstName, LastName, Address, City, StateorProvince, @PostalCode, @PhoneNumber);

VALUES

(@FirstName, @LastName, @Address, @City, @StateorProvince, @PostalCode, @PhoneNumber);

--save the new CustomerID number that was auto-generated

Select @CustID = @@identity;

--insert a new vehicle row

(@Year, @Make, @Model, @Color, @ LicensePlate@, Null, @CustID);

GO;

@@identity is a Transact-SQL Variable...

You would call the procedure like this

Execute AddCustomerVehicle 'Erika', 'Last', '123 Penny Lane', 'St. Louis', 'Mo', '20115', '3137770986', '2011', 'Jeep', 'Cherokee', 'Kiwi', '78ghMAN';