sql insert statement with guid column

[threeo]

anyone know how.....

i have a sql server table i am trying to do an insert to...
the table's last column is a unique identifier guid column

so....

when i build my insert statement....what do i put for that column?

since it's generated by sql server....i don't know what to put and it won't allow me to put nothing.

 

[jbenson001]

You would do the same as if doing an insert into a table with an identity.

Insert Into <table>(col1, col2, col3 GUIDCol)
Values (val1, val2, val3)

 

[jbenson001]

I am sorry, I have to amend my last post, you need to use this syntax:

Insert Into <table>(col1, col2, col3 GUIDCol)
Values (val1, val2, val3, NewID())

 

[threeo]

are you saying....
your table has three columns or four?
if you have 4...won't it choke on the missing comma between "col3" and "GUIDCol"?

here's my insert statement:
INSERT INTO StackTab(recId, op_id, ctl_plan_no, rowguid)
VALUES (1, '1164618', '0520040256',???)

i have no idea what to put in place of the ???

 

[threeo]

in sql server, the uniqueidentifier column is already set to perform the function NewID() - so i shouldn't need it in my query statement

 

[jbenson001]

What do you mean it is already set? Do you mean it is set as a Default? If so your statment is true, otherwise you explicitly have to call the NewID() function.

 

[threeo]

yes - as a default - when i look at the properties in sql server for that column, the default value for that column is (newid())

so....
that being the case.....

how would one build an insert statement?

 

[jbenson001]

As I said before: Assuing your table has 4 columns and the last(col4) is the GUID column:

   Insert Into <table>(col1, col2, col3)
   Values (val1, val2, val3)

You don't define the column in the insert list and you don't specify a value. On an Insert, the NewID() function will be called. Again, this works similar to and identity, you don't specify the column or value on an Insert.

 

[jbenson001]

Sorry I did not see your previous code: Here is what you should use for your table:

   INSERT INTO StackTab(recId, op_id, ctl_plan_no, rowguid)
   VALUES (1, '1164618', '0520040256')

 

[jbenson001]

Sorry.. cut and paste problem... remove the rowguid from the insert list

   INSERT INTO StackTab(recId, op_id, ctl_plan_no)
   VALUES (1, '1164618', '0520040256')

 

[threeo]

thanks man

 

[jbenson001]

No problem, glad to help, sorry for all the fixes at the end. Anyway, I hope you are understanding how it is working.

 

[chiph]

Yeah, if you have a default value set on a column, you wouldn't even mention it in your update/insert statements. The database server will supply a value itself.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first