Primary Key

Hi,
I'm looking for a way to make a primary key control in a int column (in othe
r words the app will manage the primary key value).
What's the best way to make that in SQL Server 2005? Most important, there's
a patter that allow many DB systems (like Oracle, DB2,
Firebird...)?
Thanks
MaxIf you're doing it from CLR code, consider using SMO.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Max Andr Bndchen" <nospam@.microsoft.com> wrote in message
news:utIrWfrPGHA.312@.TK2MSFTNGP12.phx.gbl...
Hi,
I'm looking for a way to make a primary key control in a int column (in
other words the app will manage the primary key value).
What's the best way to make that in SQL Server 2005? Most important, there's
a patter that allow many DB systems (like Oracle, DB2,
Firebird...)?
Thanks
Max|||> I'm looking for a way to make a primary key control in a int column (in
> other words the app will manage the primary key value).
If the application will manage (calculate and populate?) the key values,
then all you must do is add the int column and then add the primary key
constraint.

> Most important, there's a patter that allow many DB systems (like Oracle,
> DB2, Firebird...)?
Could you clarify the above question?
"Max Andr Bndchen" <nospam@.microsoft.com> wrote in message
news:utIrWfrPGHA.312@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm looking for a way to make a primary key control in a int column (in
> other words the app will manage the primary key value).
> What's the best way to make that in SQL Server 2005? Most important,
> there's a patter that allow many DB systems (like Oracle, DB2,
> Firebird...)?
> Thanks
> Max
>