USE [AIADatabaseV5] GO /****** Object: StoredProcedure [dbo].[UpdateUserProfile] Script Date: 2/1/2018 12:15:55 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: -- Create date: -- Description: -- ============================================= if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateUserProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[UpdateUserProfile] GO CREATE PROCEDURE [dbo].[UpdateUserProfile] -- Add the parameters for the stored procedure here @Id int, @FirstName VARCHAR(100), @LastName VARCHAR(100), @EmailId varchar(50), @Status int out AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; set @Status = 0; BEGIN TRY BEGIN TRANSACTION UPDATE AIAUser SET FirstName= @FirstName, LastName= @LastName, EmailId = @EmailId where Id = @Id; COMMIT TRANSACTION set @Status = 1; END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION END CATCH END GO