CapturedTech.com

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.
 Patrick Stevens
 533  246383  3/28/2024

FaceBook

Translate