How do I set up UniqueIdentifier column 1

[wmdpontius]

Am I correct in assuming that the special numeric datatype<br>'UniqueIdentifier' (16 bytes) is dynamically generated<br>upon an INSERT statement? If so, how do I define it in<br>the table and what is the correct format for the INSERT?<br><br>---the book I have just gives the specs for this<br>datatype - but no examples---

 

[palbano]

You set the IDENTITY attribute for the column in the table definition.<br><br>You ignore the column in INSERT statements and the database fills the value automatically.<br><br>Hope this helps<br>-pete

 

[wmdpontius]

Thanks. The 'IDENTITY&quot; column wasn't the one to check,<br>but it got me to looking in the right direction.<br>It is the 'IS ROWGUIDE' column that needs to be checked.<br>(Some times I just need a bump in the right direction)<br>Thanks again.&nbsp;&nbsp;&nbsp;&nbsp;Bill

 

[foxdev]

On the original question, I think you might need to use the NEWID() function to get the GUID value.<br><br>As you've already discovered, GUIDs are different from Identity columns, which are usually simply incremental integers.&nbsp;&nbsp;GUIDs, on the other hand, are supposed to be unique throughout the mapped universe. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[wmdpontius]

Right again, Robert. Since I posted the original question,<br>the author of the book &quot;Professional SQL Server 7.0<br>Programming&quot; wrote me:<br><br>CREATE TABLE Test2<br>(<br>&nbsp;&nbsp;&nbsp;&nbsp;MyID&nbsp;&nbsp;&nbsp;&nbsp;int&nbsp;&nbsp;&nbsp;&nbsp;IDENTITY&nbsp;&nbsp;&nbsp;&nbsp;PRIMARY KEY,<br>&nbsp;&nbsp;&nbsp;&nbsp;MyGUID&nbsp;&nbsp;&nbsp;&nbsp;uniqueidentifier<br>)<br><br>INSERT INTO Test2<br>&nbsp;&nbsp;&nbsp;&nbsp;VALUES<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(newid())<br><br>Thanks for the help.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Bill