CREATE PROCEDURE spAddNewAddress @AddressID char, @AddressType char, @HomeAddress varchar, @City varchar, @State varchar, @Zip varchar, @Country varchar AS INSERT INTO Address VALUES(@AddressID, @AddressType, @HomeAddress, @City, @State, @Zip, @Country) GO In the above parameters, a size needs to be added: @AddressID char(nn), @AddressType char(nn), @HomeAddress varchar(nn), @City varchar(nn), @State varchar(2), @Zip varchar(9), @Country varchar(nn) where the "nn" is the size of the field.