SET ANSI_NULLS ON GO CREATE PROCEDURE [dbo].[stpRegion_EditRegion] @RegionID int, @RegionDescription varchar(255), @LastModID int, @LastModDate datetime AS BEGIN SET NO COUNT ON; UPDATE dbo.Regions SET RegionDescription = @RegionDescription LastModID = @LastModID LastModDate = @LastModDate WHERE RegionID = @RegionID END GO