Captured Technology

Inserting a Unique Identifier (GUID) into a SQL Field

Dec 30 2008

If you have a database which contains GUIDs as a column of a table, then inserting the unique identifier into the needed column is not always straight forward. I found that converting the needed value into a unique identifier makes adding it to the database error free.

INSERT INTO SOMETABLE(GUID_1)
SELECT CAST('B14BC077-F1DF-457C-9F7E-7CB9E0BC1CF3' AS UNIQUEIDENTIFIER)

Blog Directory

Latest technology news.
 Steve Patterson
 410  245410  4/5/2017

FaceBook

Translate

Sponsors

Blog Calendar

Categories