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)