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

Question

0.00/5 (No votes)

See more:

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,..

Posted 10-Sep-12 20:30pm

cutie1

Add a Solution

Comments

Ankur^\m/ 11-Sep-12 2:57am

using uniqueidentifier as a primary key isn't considered a very good option from performance point of view. Moreover SQL Server would create a default clustered index on primary key which in this case can be a disaster as it causes high fragmentation. Review your design!

2 solutions

Solution 2

Refer Using uniqueidentifier Data[^]

Posted 10-Sep-12 20:50pm

__TR__

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bernhard Hiller · Accepted Answer · 2012-09-10T20:46:00

Solution 1

In the table designer, add "newid()" as "Default Value or Binding" for that column.

Posted 10-Sep-12 20:46pm

Bernhard Hiller

Comments

cutie1 11-Sep-12 3:04am

Thank u .But when I add like this the rows are jumbled.They are not in the order like the ones Iam inserting.How can I get in the order in which I insert?

Bernhard Hiller 11-Sep-12 3:53am

Guids are not generated in ascending order!

cutie1 11-Sep-12 3:56am

k .Thank u