Hi
How do I set a primary key to be a GUID?
That is, using the following code, I can set an integer primary key, but how
do I change it to a GUID?
Dim databaseCommand As OleDbCommand = New OleDbCommand("CREATE TABLE books
(" ID INT IDENTITY, Book VARCHAR(50), CONSTRAINT [pk_ID] PRIMARY KEY (ID))",
myDatabaseConnection)
Many thanks in advance
Geoff
12  1465 
Geoff Jones wrote: How do I set a primary key to be a GUID?
That is, using the following code, I can set an integer primary key,
but how do I change it to a GUID?
This is probably better suited to a SQL Server newsgroup (assuming it's SQL
Server you're using), but this might help. Create a "default" constraint on
the ID field which gives it the value "NewID()". This is a SQL Server
function that generates a GUID. So change your table creation for these two
SQL statements:
CREATE TABLE books
(
[ID] [varchar] (50) NOT NULL ,
[Book] [varchar] (50) NULL
CONSTRAINT [pk_ID] PRIMARY KEY ([ID])
)
ALTER TABLE [dbo].[books] ADD
CONSTRAINT [DF_books_ID] DEFAULT (newid()) FOR [ID]
Now if you insert values into the table and don't specify anything for the
ID field, it'll automatically receive a GUID for each row.
--
(O)enone
CREATE TABLE [dbo].[books] (
[book_id] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[books] ADD
CONSTRAINT [DF_books_bookid_quid] DEFAULT (newid()) FOR [book_id],
CONSTRAINT [PK_books] PRIMARY KEY CLUSTERED
(
[book_id]
) ON [PRIMARY]
GO
HTH,
Greg
"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:41***********************@news.dial.pipex.com ... Hi
How do I set a primary key to be a GUID?
That is, using the following code, I can set an integer primary key, but
how do I change it to a GUID?
Dim databaseCommand As OleDbCommand = New OleDbCommand("CREATE TABLE books
(" ID INT IDENTITY, Book VARCHAR(50), CONSTRAINT [pk_ID] PRIMARY KEY
(ID))", myDatabaseConnection)
Many thanks in advance
Geoff
On Thu, 5 Aug 2004 11:59:44 +0100, Geoff Jones wrote: That is, using the following code, I can set an integer primary key, but how
do I change it to a GUID?
Make your column type a UNIQUEIDENITFIER type
--
Chris
dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
replace certain words in my E-Mail address.
(O)enone,
I realize this isn't a SQL group, but I was curious why you chose
varchar(50) for your ID field and not the 'uniqueidentifier' data type?
Greg
"Oenone" <no***@nowhere.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl... Geoff Jones wrote: How do I set a primary key to be a GUID?
That is, using the following code, I can set an integer primary key,
but how do I change it to a GUID?
This is probably better suited to a SQL Server newsgroup (assuming it's
SQL Server you're using), but this might help. Create a "default" constraint
on the ID field which gives it the value "NewID()". This is a SQL Server
function that generates a GUID. So change your table creation for these
two SQL statements:
CREATE TABLE books
(
[ID] [varchar] (50) NOT NULL ,
[Book] [varchar] (50) NULL
CONSTRAINT [pk_ID] PRIMARY KEY ([ID])
)
ALTER TABLE [dbo].[books] ADD
CONSTRAINT [DF_books_ID] DEFAULT (newid()) FOR [ID]
Now if you insert values into the table and don't specify anything for the
ID field, it'll automatically receive a GUID for each row.
--
(O)enone
Greg Burns wrote: I realize this isn't a SQL group, but I was curious why you chose
varchar(50) for your ID field and not the 'uniqueidentifier' data
type?
Ah, primarily because I wasn't aware of it. That's a better solution.
--
(O)enone
Hi Chris
Like this you mean?
Dim databaseCommand As OleDbCommand = New OleDbCommand("CREATE TABLE books
(" ID UNIQUEIDENITFIER, Book VARCHAR(50), CONSTRAINT [pk_ID] PRIMARY KEY
(ID))",
myDatabaseConnection)
Geoff
"Chris Dunaway" <"dunawayc[[at]_lunchmeat_sbcglobal[dot]]net"> wrote in
message news:1c******************************@40tude.net.. . On Thu, 5 Aug 2004 11:59:44 +0100, Geoff Jones wrote:
That is, using the following code, I can set an integer primary key, but
how do I change it to a GUID?
Make your column type a UNIQUEIDENITFIER type
--
Chris
dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
replace certain words in my E-Mail address.
You need to set a default of NEWGUID(), or it won't "autonumber" like an
identity field.
Greg
"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:41***********************@news.dial.pipex.com ... Hi Chris
Like this you mean?
Dim databaseCommand As OleDbCommand = New OleDbCommand("CREATE TABLE books
(" ID UNIQUEIDENITFIER, Book VARCHAR(50), CONSTRAINT [pk_ID] PRIMARY KEY
(ID))",
myDatabaseConnection)
Geoff
"Chris Dunaway" <"dunawayc[[at]_lunchmeat_sbcglobal[dot]]net"> wrote in
message news:1c******************************@40tude.net.. . On Thu, 5 Aug 2004 11:59:44 +0100, Geoff Jones wrote:
That is, using the following code, I can set an integer primary key,
but how do I change it to a GUID?
Make your column type a UNIQUEIDENITFIER type
--
Chris
dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
replace certain words in my E-Mail address.
Hi Greg
Sorry, but I'm a real Newbie to all this and I don't know how to set a
default :(
Could you show me in the code example I gave?
Many thanks in advance
Geoff
P.S. And sorry for being so dim!!!!!!
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:ul**************@TK2MSFTNGP10.phx.gbl... You need to set a default of NEWGUID(), or it won't "autonumber" like an
identity field.
Greg
"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:41***********************@news.dial.pipex.com ... Hi Chris
Like this you mean?
Dim databaseCommand As OleDbCommand = New OleDbCommand("CREATE TABLE
books (" ID UNIQUEIDENITFIER, Book VARCHAR(50), CONSTRAINT [pk_ID] PRIMARY KEY
(ID))",
myDatabaseConnection)
Geoff
"Chris Dunaway" <"dunawayc[[at]_lunchmeat_sbcglobal[dot]]net"> wrote in
message news:1c******************************@40tude.net.. . On Thu, 5 Aug 2004 11:59:44 +0100, Geoff Jones wrote:
> That is, using the following code, I can set an integer primary key,
but how > do I change it to a GUID?
>
Make your column type a UNIQUEIDENITFIER type
--
Chris
dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
replace certain words in my E-Mail address.
I need more info. For being a newbie you are attempting stuff I've never
had to do in code before. :^)
I see you are using oledb, which implies to me that you are not using SQL
server. (If you're not, then all this talk of uniqueidentifiers isn't gonna
fly). If this is an Access database, I don't think you can issue the same
DDL (data denition language) SQL statements as you would for SQL server.
If it is SQL (then I would start using the SqlClient's SqlCommand object),
then I think you have to issue to a second cmd.ExecuteNonQuery after you
create the table with the first command. The second command should be
similar to this (assuming your key field is named "book_id"):
ALTER TABLE [dbo].[books] ADD
CONSTRAINT [DF_books_book_id_quid] DEFAULT (newid()) FOR [book_id],
CONSTRAINT [PK_books] PRIMARY KEY CLUSTERED
(
[book_id]
) ON [PRIMARY]
What are you trying to accomplish, why do you need to make your table on the
fly?
Greg
"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:41***********************@news.dial.pipex.com ... Hi Greg
Sorry, but I'm a real Newbie to all this and I don't know how to set a
default :(
Could you show me in the code example I gave?
Many thanks in advance
Geoff
P.S. And sorry for being so dim!!!!!!
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:ul**************@TK2MSFTNGP10.phx.gbl... You need to set a default of NEWGUID(), or it won't "autonumber" like an
identity field.
Greg
"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:41***********************@news.dial.pipex.com ... Hi Chris
Like this you mean?
Dim databaseCommand As OleDbCommand = New OleDbCommand("CREATE TABLE books (" ID UNIQUEIDENITFIER, Book VARCHAR(50), CONSTRAINT [pk_ID] PRIMARY
KEY (ID))",
myDatabaseConnection)
Geoff
"Chris Dunaway" <"dunawayc[[at]_lunchmeat_sbcglobal[dot]]net"> wrote
in message news:1c******************************@40tude.net.. .
> On Thu, 5 Aug 2004 11:59:44 +0100, Geoff Jones wrote:
>
> > That is, using the following code, I can set an integer primary
key, but how
> > do I change it to a GUID?
> >
>
> Make your column type a UNIQUEIDENITFIER type
>
> --
> Chris
>
> dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
>
> To send me an E-mail, remove the "[", "]", underscores ,lunchmeat,
and > replace certain words in my E-Mail address.
Hi Greg
I've been given a project which a colleague was working on. This isn't my
field!!! Still, it is nice to learn something new.
This is an Access database project. I'm trying to create a new database "on
the fly" with the primary key set to a GUID. I would have thought this an
easy thing to do - obviously, I am very wrong :)
Geoff
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:O9**************@TK2MSFTNGP12.phx.gbl... I need more info. For being a newbie you are attempting stuff I've never
had to do in code before. :^)
I see you are using oledb, which implies to me that you are not using SQL
server. (If you're not, then all this talk of uniqueidentifiers isn't
gonna fly). If this is an Access database, I don't think you can issue the same
DDL (data denition language) SQL statements as you would for SQL server.
If it is SQL (then I would start using the SqlClient's SqlCommand object),
then I think you have to issue to a second cmd.ExecuteNonQuery after you
create the table with the first command. The second command should be
similar to this (assuming your key field is named "book_id"):
ALTER TABLE [dbo].[books] ADD
CONSTRAINT [DF_books_book_id_quid] DEFAULT (newid()) FOR [book_id],
CONSTRAINT [PK_books] PRIMARY KEY CLUSTERED
(
[book_id]
) ON [PRIMARY]
What are you trying to accomplish, why do you need to make your table on
the fly?
Greg
"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:41***********************@news.dial.pipex.com ... Hi Greg
Sorry, but I'm a real Newbie to all this and I don't know how to set a
default :(
Could you show me in the code example I gave?
Many thanks in advance
Geoff
P.S. And sorry for being so dim!!!!!!
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:ul**************@TK2MSFTNGP10.phx.gbl... You need to set a default of NEWGUID(), or it won't "autonumber" like
an identity field.
Greg
"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:41***********************@news.dial.pipex.com ...
> Hi Chris
>
> Like this you mean?
>
> Dim databaseCommand As OleDbCommand = New OleDbCommand("CREATE TABLE
books > (" ID UNIQUEIDENITFIER, Book VARCHAR(50), CONSTRAINT [pk_ID] PRIMARY KEY > (ID))",
> myDatabaseConnection)
>
> Geoff
>
> "Chris Dunaway" <"dunawayc[[at]_lunchmeat_sbcglobal[dot]]net"> wrote in > message news:1c******************************@40tude.net.. .
> > On Thu, 5 Aug 2004 11:59:44 +0100, Geoff Jones wrote:
> >
> > > That is, using the following code, I can set an integer primary key, but
> how
> > > do I change it to a GUID?
> > >
> >
> > Make your column type a UNIQUEIDENITFIER type
> >
> > --
> > Chris
> >
> > dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
> >
> > To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and > > replace certain words in my E-Mail address.
>
>
Since it is Access, you will not be able to use the uniqueidentifier data
type. You also won't be able to use the NEWGUID() function. Those are both
SQL server specific.
My Access exposure is limited to 97 version. Do the newer version have
better support for GUIDs?
I see in 97 that you can use an Access datatype autonumber and change the
field size to "Replication ID". It seems to be making GUIDs.
Unfortunately, I have no idea how to make such a beast using DDL.
Greg
"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:41***********************@news.dial.pipex.com ... Hi Greg
I've been given a project which a colleague was working on. This isn't my
field!!! Still, it is nice to learn something new.
This is an Access database project. I'm trying to create a new database
"on the fly" with the primary key set to a GUID. I would have thought this an
easy thing to do - obviously, I am very wrong :)
Geoff
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:O9**************@TK2MSFTNGP12.phx.gbl... I need more info. For being a newbie you are attempting stuff I've
never had to do in code before. :^)
I see you are using oledb, which implies to me that you are not using
SQL server. (If you're not, then all this talk of uniqueidentifiers isn't gonna fly). If this is an Access database, I don't think you can issue the
same DDL (data denition language) SQL statements as you would for SQL server.
If it is SQL (then I would start using the SqlClient's SqlCommand
object), then I think you have to issue to a second cmd.ExecuteNonQuery after you
create the table with the first command. The second command should be
similar to this (assuming your key field is named "book_id"):
ALTER TABLE [dbo].[books] ADD
CONSTRAINT [DF_books_book_id_quid] DEFAULT (newid()) FOR [book_id],
CONSTRAINT [PK_books] PRIMARY KEY CLUSTERED
(
[book_id]
) ON [PRIMARY]
What are you trying to accomplish, why do you need to make your table on
the fly?
Greg
"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:41***********************@news.dial.pipex.com ... Hi Greg
Sorry, but I'm a real Newbie to all this and I don't know how to set a
default :(
Could you show me in the code example I gave?
Many thanks in advance
Geoff
P.S. And sorry for being so dim!!!!!!
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:ul**************@TK2MSFTNGP10.phx.gbl...
> You need to set a default of NEWGUID(), or it won't "autonumber"
like an > identity field.
>
> Greg
>
> "Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
> news:41***********************@news.dial.pipex.com ...
> > Hi Chris
> >
> > Like this you mean?
> >
> > Dim databaseCommand As OleDbCommand = New OleDbCommand("CREATE
TABLE books
> > (" ID UNIQUEIDENITFIER, Book VARCHAR(50), CONSTRAINT [pk_ID]
PRIMARY KEY > > (ID))",
> > myDatabaseConnection)
> >
> > Geoff
> >
> > "Chris Dunaway" <"dunawayc[[at]_lunchmeat_sbcglobal[dot]]net">
wrote in > > message news:1c******************************@40tude.net.. .
> > > On Thu, 5 Aug 2004 11:59:44 +0100, Geoff Jones wrote:
> > >
> > > > That is, using the following code, I can set an integer
primary key, > but
> > how
> > > > do I change it to a GUID?
> > > >
> > >
> > > Make your column type a UNIQUEIDENITFIER type
> > >
> > > --
> > > Chris
> > >
> > > dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
> > >
> > > To send me an E-mail, remove the "[", "]", underscores
,lunchmeat, and > > > replace certain words in my E-Mail address.
> >
> >
>
>
This may be of help to you: http://www.smithvoice.com/dbcopier.aspx
Greg
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:ei**************@tk2msftngp13.phx.gbl... Since it is Access, you will not be able to use the uniqueidentifier data
type. You also won't be able to use the NEWGUID() function. Those are
both SQL server specific.
My Access exposure is limited to 97 version. Do the newer version have
better support for GUIDs?
I see in 97 that you can use an Access datatype autonumber and change the
field size to "Replication ID". It seems to be making GUIDs.
Unfortunately, I have no idea how to make such a beast using DDL.
Greg
"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:41***********************@news.dial.pipex.com ... Hi Greg
I've been given a project which a colleague was working on. This isn't
my field!!! Still, it is nice to learn something new.
This is an Access database project. I'm trying to create a new database
"on the fly" with the primary key set to a GUID. I would have thought this
an easy thing to do - obviously, I am very wrong :)
Geoff
"Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
news:O9**************@TK2MSFTNGP12.phx.gbl... I need more info. For being a newbie you are attempting stuff I've never had to do in code before. :^)
I see you are using oledb, which implies to me that you are not using SQL server. (If you're not, then all this talk of uniqueidentifiers isn't
gonna fly). If this is an Access database, I don't think you can issue the same DDL (data denition language) SQL statements as you would for SQL
server.
If it is SQL (then I would start using the SqlClient's SqlCommand object), then I think you have to issue to a second cmd.ExecuteNonQuery after
you create the table with the first command. The second command should be
similar to this (assuming your key field is named "book_id"):
ALTER TABLE [dbo].[books] ADD
CONSTRAINT [DF_books_book_id_quid] DEFAULT (newid()) FOR [book_id],
CONSTRAINT [PK_books] PRIMARY KEY CLUSTERED
(
[book_id]
) ON [PRIMARY]
What are you trying to accomplish, why do you need to make your table
on the fly?
Greg
"Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
news:41***********************@news.dial.pipex.com ...
> Hi Greg
>
> Sorry, but I'm a real Newbie to all this and I don't know how to set
a > default :(
>
> Could you show me in the code example I gave?
>
> Many thanks in advance
>
> Geoff
>
> P.S. And sorry for being so dim!!!!!!
>
> "Greg Burns" <greg_burns@DONT_SPAM_ME_hotmail.com> wrote in message
> news:ul**************@TK2MSFTNGP10.phx.gbl...
> > You need to set a default of NEWGUID(), or it won't "autonumber"
like an > > identity field.
> >
> > Greg
> >
> > "Geoff Jones" <ge***@NODAMNSPAM.com> wrote in message
> > news:41***********************@news.dial.pipex.com ...
> > > Hi Chris
> > >
> > > Like this you mean?
> > >
> > > Dim databaseCommand As OleDbCommand = New OleDbCommand("CREATE
TABLE > books
> > > (" ID UNIQUEIDENITFIER, Book VARCHAR(50), CONSTRAINT [pk_ID] PRIMARY KEY
> > > (ID))",
> > > myDatabaseConnection)
> > >
> > > Geoff
> > >
> > > "Chris Dunaway" <"dunawayc[[at]_lunchmeat_sbcglobal[dot]]net"> wrote in
> > > message news:1c******************************@40tude.net.. .
> > > > On Thu, 5 Aug 2004 11:59:44 +0100, Geoff Jones wrote:
> > > >
> > > > > That is, using the following code, I can set an integer primary key,
> > but
> > > how
> > > > > do I change it to a GUID?
> > > > >
> > > >
> > > > Make your column type a UNIQUEIDENITFIER type
> > > >
> > > > --
> > > > Chris
> > > >
> > > > dunawayc[AT]sbcglobal_lunchmeat_[DOT]net
> > > >
> > > > To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
> > > > replace certain words in my E-Mail address.
> > >
> > >
> >
> >
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Louis Frolio |
last post by:
Greetings All, I have read many upon many articles here regarding GUID
data types and uniqueness. There have been many opinions regarding
the effectiveness of GUID's and when they should/should...
|
by: Jim Heavey |
last post by:
When I use the new(Guid), the GUID which is generated is all zeros. Is
there a technique for the system to assign a real Guid? Do I have to
manually calculate a GUID?
|
by: Rene |
last post by:
I am using the Guid.Empty value ("00000000-0000-0000-0000-000000000000") to
represent a special meaning. The problem is that I don't know if there is a
chance that a command like...
|
by: Nak |
last post by:
Hi there,
Does anyone know how I would get the value of the assembly GUID in code
from within the same application? Thanks in advance.
Nick.
--...
|
by: rcolby |
last post by:
Evening,
Wondering if someone can point me in the right direction, on how I would
compare a system.guid with a system.byte.
system.guid (pulled from sql server table with a data type of...
|
by: George |
last post by:
I want to create a unique id for each of a set of objects.
These ids may be generated on multiple machines simultaneously and must all
be different to each other.
There are an undefined number...
|
by: Wolf |
last post by:
Hi
I am trying to set a property(PartyHomeAddressID) = to a guid in a ini
file.
But everytime when the ini file has an empty guid it breaks with an
error tellin me a guid is 32 char long with 4...
|
by: Michael Primeaux |
last post by:
I have a simple .NET 2.0 web service created with VS.NET 2005 with a single
web method with the following signature:
void HelloWorld(Guid parameter1);
When calling this method I receive the...
|
by: Troll |
last post by:
Windows XP Pro
VS 2005 & C# (I'm fairly new to C# but have doing VB.Net going on 2yrs and VB6 for 5yrs.)
I'm using C# to build a custom RSS generator. I'm having trouble building the guid...
|
by: Marc |
last post by:
Hi, I don't get it I cannot get this to work, can somebody give me a hint
Table1 contains a field Id which is a GUID as primary key and DATA a string,
I want to insert a new row but it does not...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
