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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-08 : 08:10:06
|
| Mike writes "hi, i have this situation, i have a transaction table and a transaction detail table, normally i would have an identity and use that identity to insert the details in the other table for exampletransaction-----------------------trxnumber -- int identitytrxtdate -- datetimetrxtotal -- moneytransaction detail----------------------trxnumber inttrxitem inttrxquantity intnormally i would insert the transaction record , retreive the identity and use it as a reference in the transaction detaili a new in sql ce business and i read i have add a uniqueidentifier instead of an identity in order to prevent duplicating records.. if ther are more than one pocket pc....if thats the case, how do i link those tables? to push them via rda back to the sqlserver...???pleae help me... thanxMikeInSandals" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-08 : 08:24:20
|
| Easiest to allocate the guid on the client but you can still use newid() on the server to allocate one before the insert.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Uniqueidentifer