Anil Singh | Code-sample.com

ALTER PROCEDURE [dbo] . [UpdateUserProfile] (   @EmailID NVARCHAR ( 150 )   , @FirstName NVARCHAR ( 100 )   , @LastName NVARCHAR ( 100 )   , @Mobile NVARCHAR ( 15 )   , @AlternateContact NVARCHAR ( 15 )   , @Gender CHAR ( 1 )   , @DOB datetime   , @Address NVARCHAR ( MAX )   , @ShortBio NVARCHAR ( MAX ) ) AS BEGIN DECLARE @REST INT SET @REST = ( SELECT COUNT (*) FROM UserProfile WHERE EmailId = @EmailID ) IF ( @REST = 0 )          INSERT INTO UserProfile (              EmailId             , Gender             , DOB             , Address             , ShortBio   ...