Sql

Search

sql server convert to guid

DECLARE @uuid VARCHAR(50)
SET @uuid = 'a89b1acd95016ae6b9c8aabb07da2010'
SELECT  CAST(
        SUBSTRING(@uuid, 1, 8) + '-' + SUBSTRING(@uuid, 9, 4) + '-' + SUBSTRING(@uuid, 13, 4) + '-' +
        SUBSTRING(@uuid, 17, 4) + '-' + SUBSTRING(@uuid, 21, 12)
        AS UNIQUEIDENTIFIER)

Comment

PREVIOUS	NEXT

Code Example
Sql :: show oracle parameters
Sql :: how to upper case in sql
Sql :: mysql loop
Sql :: unable to convert mysql date/time value to system.datetime
Sql :: sql query to select data between two dates
Sql :: QL HAVING Keyword
Sql :: sql server select another database
Sql :: rollback in sql
Sql :: 2nd max salary query in sql
Sql :: select users with same username
Sql :: mysql where length greater than
Sql :: oracle create table primary key
Sql :: postgresql function round
Sql :: oracle right characters
Sql :: mysql on duplicate key update get value from values
Sql :: ignore case in string sql
Sql :: uninstall mysql ubuntu 18.04 stackoverflow
Sql :: deleting database in sql
Sql :: oracle all dates between two dates
Sql :: difference between 2 query results sql server
Sql :: SQL Remove Primary Key Constraint - MySQL
Sql :: delete from table sql
Sql :: postgresql create table as select
Sql :: on update current_timestamp jpa
Sql :: sql roll up rows into columns
Sql :: delete all duplicate rows keep the latest except for one in mysql
Sql :: See Foreign Key
Sql :: google cloud sql postgres url example
Sql :: download sql server 2014
Sql :: docker hub mysql

Search

SQL

sql server convert to guid

ADD CONTENT