Im still learning my way around SQL and queries and i was wondering :
How do you get a SQL Table to autoincrement a Guid? (is it "Is Identity?" or "RowGuid"...)
How would i create a new row with a new Guid, and insert into the values i want without specifying the Guid?
You would need to use NewID() to get the next random GUID.
INSERT INTO yourTable (col1, col2,...) VALUES (@.val1, NewID(), @.val3,...)
No comments:
Post a Comment