Loading

How can the GUID (uniqueidentifier) be generated directly in SQL?

haji

14y1.4kSQL

Hi
I am inserting values in a table directly without writing the query for create table.
The columns I am using are Id(uniqueidentifier,primarykey),Name(varchar).Now I can insert the Name values directly but how can the GUID can automatically generated when I move from one row to other row?Because when I dont insert anything thinking it would be generated and moving on to next row it is giving error :Column values cannot be null.How to fix it?

Thanks,..

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sukesh Marla14y ago
Accepted answer
Put Default Value for Column as NewId()

NewId() function gernerates and returns UniqueIdentifier value

Or Even in Insert query call this functiion to explictly insert the value,.

Check this is correct answeer if it helped.