•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 455,968 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,746 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 532 | Replies: 1
 |
•
•
Join Date: Aug 2007
Posts: 98
Reputation: 
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
Hi guys!
I was wondering if comeone could help me with transferring data from one table to another.
I am storing information of all customers who make an enquiry (PotentialCustomers) then transfering their details into a Customers table if they decide to purchase something from the company.
How would I go about keeping the ID from the PotentialCustomers table when the data is tranfered into the Customers table and ensuring that the ID is not the same as a different customer already in the Customers table?
I am aware of the keep identity check box and the Identity_insert statement but is there a way of ensuring that all the id's are different so when I do transfere there isnt two the same?
Thanks
GLT
I was wondering if comeone could help me with transferring data from one table to another.
I am storing information of all customers who make an enquiry (PotentialCustomers) then transfering their details into a Customers table if they decide to purchase something from the company.
How would I go about keeping the ID from the PotentialCustomers table when the data is tranfered into the Customers table and ensuring that the ID is not the same as a different customer already in the Customers table?
I am aware of the keep identity check box and the Identity_insert statement but is there a way of ensuring that all the id's are different so when I do transfere there isnt two the same?
Thanks
GLT
•
•
Join Date: Aug 2006
Location: Egypt
Posts: 763
Reputation:
Rep Power: 4
Solved Threads: 59
Master Poster
Make ID column Identity and incremented by one each time. you won't insert it by your hand and it kept unique.
B.Sc Computer Science, Helwan University
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
Microsoft Student Partner
Personal blog http://ramymahrous.blogspot.com/
Arabic technical blog http://fci-h-ar.blogspot.com/
English technical blog http://fci-h.blogspot.com/
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
access ajax asp breach broadband code combo crime daniweb data data protection data transfer database developer development drive dropdownlist forensics government hacker hard hardware hitachi internet linux microsoft module msdn net news office reuse security software sql storage survey terabyte vista web wikipedia
- Transmitting Data Via Modem On PSTN Line Using ??? (Visual Basic 4 / 5 / 6)
- transfering data from one web to other website (ASP.NET)
- Whats the eaiest way from transfering data from a PC to a Laptop? (Troubleshooting Dead Machines)
- Transfering data from a hard drive. (Troubleshooting Dead Machines)
- transfering data to pen drive (Getting Started and Choosing a Distro)
- transfering data from one hard drive to another.... (Storage)
- PHP Login (PHP)
Other Threads in the MS SQL Forum
- Previous Thread: Applying Constraints after creating a table.
- Next Thread: extracting comma separated values
