Thanks for your time

Table Definition

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[customers](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Description] [nvarchar](300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[ContactPhone] [nvarchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Email] [nvarchar](75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[Street] [nvarchar](75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[City] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Zip] [nvarchar](12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[StateID] [int] NULL,

[Created] [datetime] NOT NULL CONSTRAINT [DF_clients_dteCreate] DEFAULT (getdate()),

CONSTRAINT [PK_customers] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

Stored Procedure to insert

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[sp_insCustomers]

-- Add the parameters for the stored procedure here

(@Name nvarchar(50)

,@Description nvarchar(300)

,@ContactPhone nvarchar(12)

,@Email nvarchar(75)

,@Street nvarchar(75)

,@City nvarchar(50)

,@Zip nvarchar(12)

,@StateID int)

AS

BEGIN

SET NOCOUNT ON;

INSERT INTO [dbo].[customers]

([Name]

,[Description]

,[ContactPhone]

,[Email]

,[Street]

,[City]

,[Zip]

,[StateID])

VALUES

(@Name

,@Description

,@ContactPhone

,@Email

,@Street

,@City

,@Zip

,@StateID)

select @@Identity

END