how to enter values in rowguid column?

Question

can anyone please tell me the right way to insert values in the rowguid column of the table? I m using sql server management studio

Answer 1

use the NEWID() function to generate one:

CREATE TABLE myTable(GuidCol uniqueidentifier
                    ,NumCol int)
INSERT INTO myTable Values(NEWID(), 4)
SELECT * FROM myTable

or you can set it as a defualt value:

CREATE TABLE myTable(GuidCol uniqueidentifier DEFAULT NEWSEQUENTIALID()
                    ,NumCol int)
INSERT INTO myTable (NumCol) Values(4)
SELECT * FROM myTable

Answer 2

You can Set NEWSEQUENTIALID() as Default in table

CREATE TABLE GuidTable
(
ID UNIQUEIDENTIFIER DEFAULT NEWSEQUENTIALID() PRIMARY KEY,
TEST INT
)

Read more about it here

http://msdn.microsoft.com/en-us/library/ms189786.aspx

Answer 3

Assuming that you have a uniqueidentifier column rg in your table t which is set to be the rowguid:

INSERT INTO TABLE t (rg) VALUES (NEWID())

or

INSERT INTO TABLE t (rg) VALUES (NEWSEQUENTIALID())

Answer 4

It's a uniqueidentifier column

You can send a value like "6F9619FF-8B86-D011-B42D-00C04FC964FF", or use NEWID/NEWSEQUENTIALID functions to generate one

Answer 5

Thanks everyone. It generate automatically in management studio