haji

haji

  • NA
  • 7
  • 17.5k

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

Sep 11 2012 2:31 AM
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,..

Answers (1)