Stored Procedure

sp_InsertNewPerson

USE PersonDatabase

GO

CREATE PROCEDURE sp_InsertNewPerson

  @PrefixText varchar(200),  

  @FirstNameText varchar(200),

  @LastnameText varchar(200),

  @SuffixText varchar(200),

  @StreetNumber varchar(20),

  @Street varchar(200),

  @City varchar(200),

  @State varchar(2),

  @Zipcode  varchar(10)

AS

BEGIN

INSERT dbo.Persons DEFAULT VALUES

DECLARE @PersonPK INT

SET @PersonPK= @@Identity

INSERT INTO [PersonDatabase].[dbo].[Names]

           ([PersonID]

           ,[PrefixText]

           ,[FirstNameText]

           ,[LastNameText]

           ,[Suffixtext])

     VALUES

           (@PersonPK

           ,@PrefixText

           ,@FirstNameText

           ,@LastNameText

           ,@SuffixText)

INSERT INTO [PersonDatabase].[dbo].[Addresses]

           ([PersonID]

           ,[StreetNumber]

           ,[Street]

           ,[City]

           ,[State]

           ,[Zipcode])

     VALUES

          (@PersonPK

           ,@StreetNumber

           ,@Street

           ,@City

           ,@State

           ,@Zipcode)

END    

Stored Procedure

sp_DeletePerson

CREATE PROCEDURE sp_DeletePerson

 @PersonID INT 

AS

BEGIN

 DELETE FROM Names WHERE PersonID = @PersonID

 DELETE FROM Addresses WHERE PersonID = @PersonID

 DELETE FROM Persons WHERE id = @PersonID

END