Click here to Skip to main content
15,884,177 members
Home / Discussions / Database
   

Database

 
QuestionSelect Into Statement Clarity Pin
Vimalsoft(Pty) Ltd24-Jul-08 5:31
professionalVimalsoft(Pty) Ltd24-Jul-08 5:31 
AnswerRe: Select Into Statement Clarity Pin
Tim Carmichael24-Jul-08 5:44
Tim Carmichael24-Jul-08 5:44 
GeneralRe: Select Into Statement Clarity Pin
Vimalsoft(Pty) Ltd24-Jul-08 8:06
professionalVimalsoft(Pty) Ltd24-Jul-08 8:06 
AnswerRe: Select Into Statement Clarity Pin
TheFM23424-Jul-08 8:30
TheFM23424-Jul-08 8:30 
GeneralRe: Select Into Statement Clarity Pin
Vimalsoft(Pty) Ltd24-Jul-08 8:34
professionalVimalsoft(Pty) Ltd24-Jul-08 8:34 
GeneralRe: Select Into Statement Clarity Pin
Ashfield25-Jul-08 9:24
Ashfield25-Jul-08 9:24 
QuestionMultiple databases from a master database Pin
Brendan Vogt24-Jul-08 1:18
Brendan Vogt24-Jul-08 1:18 
AnswerRe: Multiple databases from a master database Pin
TheFM23424-Jul-08 3:31
TheFM23424-Jul-08 3:31 
If you structure the tables correctly, you will be able to contain it in a single database.

Use a single user/login table(s) for both sites, this way you wont have to import anything if you kept the site's databases different.

If product's are a one to one relationship to countries (one product can be sold in one county), then you can have a product data set with a column for the country ID. Have a table with the countries (A and B in your example), then join the products and country.

If one product can belong to both countries, then you can have a product table with country "flags" (a bit column with 1 indicating yes and 0 indicating no). So you might have productid = 1, country A = 1, and country B = 1 meaning that the product is available in both countries. If you do expand, then you will have to keep adding countries. To avoid that, you can have a "mapping" table where you map single products to multiple countries (being a true one to many build).

I'm assuming that both sites will use a common database server.
GeneralRe: Multiple databases from a master database Pin
Brendan Vogt24-Jul-08 5:37
Brendan Vogt24-Jul-08 5:37 
JokeRe: Multiple databases from a master database Pin
SimulationofSai24-Jul-08 12:37
SimulationofSai24-Jul-08 12:37 
Questionacess database and bind to the datagrid using c# in ado.net Pin
swapnamoturu23-Jul-08 20:50
swapnamoturu23-Jul-08 20:50 
AnswerRe: acess database and bind to the datagrid using c# in ado.net Pin
Vimalsoft(Pty) Ltd23-Jul-08 23:37
professionalVimalsoft(Pty) Ltd23-Jul-08 23:37 
Question"loop" this for me please Pin
nelsonpaixao23-Jul-08 13:40
nelsonpaixao23-Jul-08 13:40 
AnswerRe: "loop" this for me please Pin
Mycroft Holmes23-Jul-08 20:29
professionalMycroft Holmes23-Jul-08 20:29 
AnswerRe: "loop" this for me please Pin
BadhShah24-Jul-08 2:45
BadhShah24-Jul-08 2:45 
GeneralRe: "loop" this for me please Pin
nelsonpaixao24-Jul-08 12:10
nelsonpaixao24-Jul-08 12:10 
QuestionNested Aggregate Function Pin
Lash2023-Jul-08 9:56
Lash2023-Jul-08 9:56 
AnswerRe: Nested Aggregate Function Pin
TheFM23423-Jul-08 11:28
TheFM23423-Jul-08 11:28 
GeneralRe: Nested Aggregate Function Pin
Wendelius23-Jul-08 11:53
mentorWendelius23-Jul-08 11:53 
AnswerRe: Nested Aggregate Function Pin
Wendelius23-Jul-08 11:35
mentorWendelius23-Jul-08 11:35 
GeneralRe: Nested Aggregate Function Pin
Lash2023-Jul-08 12:23
Lash2023-Jul-08 12:23 
GeneralSQL Advice needed [modified] Pin
StevenWalsh23-Jul-08 8:22
StevenWalsh23-Jul-08 8:22 
GeneralRe: SQL Advice needed Pin
PIEBALDconsult23-Jul-08 8:51
mvePIEBALDconsult23-Jul-08 8:51 
GeneralRe: SQL Advice needed Pin
Ennis Ray Lynch, Jr.23-Jul-08 8:54
Ennis Ray Lynch, Jr.23-Jul-08 8:54 
GeneralRe: SQL Advice needed Pin
StevenWalsh23-Jul-08 9:54
StevenWalsh23-Jul-08 9:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.