So I have this table with a bunch of nullable fields. Amoung them is a uniqueIdentifier column(FK_ID) that is also nullable. I also have an ID field(TableA_ID) which gets set by NewID() as the default value. I do an insert like so....
INSERT INTO [TableA](FK_ID)
(1 row(s) affected)
I see the following result in TableA
Why can't I insert a uniqueidentifier?