I'm having trouble inserting a uniqueidentifer to a rowguid column in my db. I tried using NEWID() function within my ASP page but that doesn't seem to work. Does anyone have any experience with this datatype.
That's really good to know. Now I must ask this question. Because I have a rowguid column in my db, when appending a row to a table from my web page. I get an error from my browser stating that I cannot enter a NULL value to 'rowguid'. I don't have any reference to the rowguid column in my code and it's still gives me this error. I've read that the uniqueidentifier column is not automatically generated and has to be instructed to through the NEWID() fuction. My question is how do I do that through asp or is this something that has to be set in table through SQL only. I'm very confused at this point.