Anil Singh | Code-sample.com

--CREATE A FUNCTION FOR ADD TWO USER INPUT VALUES. CREATE FUNCTION AddFun_sp (@NumIst INT , @NumpIInd INT ) RETURNS INT AS BEGIN DECLARE @Result as int SET @Result = @NumIst + @NumpIInd RETURN @Result END --CALL A FUNCTION IN STORE PROCEDURE. CREATE PROCEDURE usp_CallAfunction ( @IstVar INT , @IIndVar INT ) AS BEGIN DECLARE @sp AS INT SET @sp = dbo . AddFun1 (@IstVar,@IIndVar) PRINT @sp END --EXECUTE STORE PROCEDURE FOR OUTPUT RESULT. EXECUTE dbo . usp_CallAfunction '10' , '20' --RESULT IS 30

Create function for   convert nvarchar to uniqueidentifier as given below. ALTER FUNCTION [dbo] . [Str2Uniqe] ( @s VARCHAR ( 50 )) RETURNS UNIQUEIDENTIFIER AS BEGIN     SET @s = REPLACE ( REPLACE ( @s , '0x' , '' ), '-' , '' )     SET @s = STUFF ( STUFF ( STUFF ( STUFF ( @s , 21 , 0 , '-' ), 17 , 0 , '-' ), 13 , 0 , '-' ), 9 , 0 , '-' )     RETURN CAST ( @s AS UNIQUEIDENTIFIER ) END Select created function result as given below. DECLARE @guid VARCHAR ( 50 ) SET @guid = '3b8766fa720043af9e21c5bc6bbbdea5' SELECT dbo . Str2Uniqe ( @guid ) Result as given below.