Creating Primary Keys - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Creating Primary Keys

Author

Topic

Saif ur Rehman
Starting Member

3 Posts

Posted - 2011-01-10 : 01:31:10

Dear Friends,

I have developed a web application, it is now used by four Data Entry Operators (DEOs) at a time, now i want to display a unique Primary Key value to each DEOs on four different Clint machines, Can any one give me a simple solution to this problem.
if any confusion in understating this issue, kindly let me know,

thanks, my application is stuck with this problem
Looking for a favorable reply..

thanks
Saifi

Saifi

shaggy
Posting Yak Master

248 Posts

Posted - 2011-01-10 : 01:39:45

use identity column

Saif ur Rehman
Starting Member

3 Posts

Posted - 2011-01-10 : 02:00:31

thank a lot,
Kindly tell me, there are four machines having record displaying (which are not still added to DB)with a Value at the top of each form in the machine..

mean before inserted can i display different Primary Key value to four or more machines at time..
Kindly give me a link where this problem has been solved...

Saifi

Saifi

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-01-10 : 05:25:23

The most popular approaches to this problem is to either use a GUID column as your primary key (which is really horrible for performance, storage and fragmentation) or to introduce a second column in your table to store which client machine the data comes from.

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-01-10 : 10:45:15

quote:
Originally posted by Saif ur Rehman

thank a lot,
Kindly tell me, there are four machines having record displaying (which are not still added to DB)with a Value at the top of each form in the machine..

mean before inserted can i display different Primary Key value to four or more machines at time..
Kindly give me a link where this problem has been solved...

Saifi

Saifi

before doing save why do you need to display value?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources