Convert nvarchar to uniqueidentifier in SQL Server

Convert nvarchar to uniqueidentifier in SQL Server

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.


ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

Convert nvarchar to uniqueidentifier in SQL Server Convert nvarchar to uniqueidentifier in SQL Server Reviewed by Anil Singh on 2:56 AM Rating: (5)
www.code-sample.com/. Powered by Blogger.
^