SQL Server | Convert Varchar to UniqueIdentifier - Software Engineer and UX Designer

November 7 • 3:22 am

Tags:

ASP.Net Cast String to UniqueIdebtifier Convert String to GUID Convert Varchar to UniqueIdentifier Design + Development Development Tools Microsoft SQL Server Sql Server 2005 Sql Server 2008 Utilities Windows 7

There are 2 ways to Convert a string to a UniqueIdentifier (GUID) in SQL Server:

SELECT CAST(‘449141d9-86c9-449d-be2c-1f171b4f4567’ as UNIQUEIDENTIFIER)

SELECT CONVERT(UNIQUEIDENTIFIER, ‘449141d9-86c9-449d-be2c-1f171b4f4567’)

Categories

2 Responses

Joel Brooks says:

September 5, 2012 at 2:37 am

thanks dude – you saved my bacon!

Reply
Siva says:

September 17, 2018 at 11:13 pm

Hi, I have a question.
Want to know which one will perform better when converting varchar to uniqueidentifier OR nvarchar to uniqueidentifier? Thanks in advance!

Reply

Leave a Reply Cancel reply