lw_changePerson.sql

If Exists (Select * From sysobjects Where name = N'lw_changePerson' And user_name(uid) = N'dbo')
    Drop Procedure dbo.lw_changePerson
Go

 
CREATE Procedure lw_changePerson (
      @personId int,
      @studentId nvarchar(12),
      @firstName nvarchar(50),
      @lastName nvarchar(50),
      @alias nvarchar(50),
      @street nvarchar(60),
      @city nvarchar(15),
      @region nvarchar(15),
      @postalCode nvarchar(10),
      @country nvarchar(15),
      @phone nvarchar(24),
      @contact nvarchar(50),
      @contactPhone nvarchar(24),
      @contactRelationship  nvarchar(24),
      @releaseInfo nvarchar(16)
)
As
 set nocount on
   update person set studentId=@studentId, firstName=@firstName,
          lastName=@lastName, alias=@alias, street=@street, city=@city,
          region=@region, postalCode=@postalCode, country=@country,
          phone=@phone, contact=@contact, contactPhone=@contactPhone,
          contactRelationShip=@contactRelationship, releaseInfo=@releaseInfo 
          where personId=@personId
   return @@ERROR
     

Go