|
|
|
|
|
| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
How many columns and unions can I have? |
|
From: |
Vic |
|
Date: |
12/13/2000 11:47:59 AM |
|
IP: |
213.200.128.39 |
Hello! I've got two different but simular db-questions, which I hope someone with more experience could help me with:
1)How many columns can I have in an access-table? I've got this table which I would like to contain about 150 different columns. Many of them will be empty for most posts, and most of them will only contain a number (an ID for another post in another table). Is it to many?
2)How many queries can I "UNION" within an access-query? I would like to have MANY. How many are too many? The queries will be filtered, so for most posts, most of them will not result in anything. But just like with the columns, I need them all for what I'm trying to do... Sorry if these are stupid questions but I haven't found the answers to them anywhere...
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
