Ads

Captured Technology - Blog

Inserting a Unique Identifier (GUID) into a SQL Field

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
 532  246381  3/14/2024

Translate

Categories

Blog Calendar