Hi,
I've got a table which has a GUID field type, with the default value set to newid().
However, when I perform an insert I am deliberately setting the value of that field myself.
The problem is that if I perform a get for the same row immediately after the insert, the value of that field has changed to the value generated by the default value setting.
Is this a change in feature or a bug?
Cheers,
Matt.