Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wndrboy2k3
Starting Member
37 Posts |
 Posted - 2009-02-08 : 03:21:24
|
| I'm new to using ROWGUID. I didn't actually know what they were until I saw them in the Adventure Works database. I've done a bit of research but can't seem to find the answer to what seems like a simple question.Can you make them auto generate? Or do you have to type them in manually each and every time?Any feedback would be greatly appreciated.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-08 : 03:28:47
|
| yup. you can make them auto generate using NEWID() or NEWSEQUENTIALID() functions.As name suggets former one generates a random GUID each time while later generates GUID sequentially. |
 |
|
|
wndrboy2k3
Starting Member
37 Posts |
Posted - 2009-02-08 : 03:57:19
|
| Thanks, I did this but it wasn't working. It was because my row just wasn't committing. Thank you so much! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-08 : 21:18:53
|
welcome  |
|
|
|
|
|
|
ROWGUID Do you type them in manually?