Database Q & A

Results 1 to 2 of 2

Thread: Database Q & A

  1. #1
    Skinny Guest

    Default Database Q & A

    SQLServer certainly wouldn&#039t have any trouble with 5000 tables (assuming that you have the hardware for it), but I still wouldn&#039t go at it this way. It would would be better to store the information in your 4 tables and then run a SQL select query to gather the information for a particular person.<BR><BR>SELECT * FROM cutomers WHERE custID = thisCustomer<BR><BR>You can do all of theis from pre-compiled stored procedures that will take parameters and will be lightning fast.<BR>Hope this helps.

  2. #2
    Sorry Guest

    Default RE: Database Q & A

    this got posted to the wrong place, please ignore

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts