Dynamic SQL Statement With SQL 6.5
I don't know SQL Server6.5, as for SQLServer7.0, the limit of tables in
"SELECT..." statement is 256, while each database can hold up to
2,147,483,647 tables.
Just curious, what kind of database you are designing that may hold
unlimited number of , or a few millions of, tables in it?
Quote:
> I am writing a very dynamic database app. The user is able to select
> fields from any number of tables. So far, there are only six tables,
> but as more users are added (from different departments), the tables
> will increase. I know that there is a limit to the number of joins that
> SQL Server 6.5 can handle. So, my question to anyone and everyone is...
> How do you create a dynamic SQL statement, so that an unlimited number
> of tables can be added? I know from talking to my boss, that it IS
> possible. He just won't share the information with me at this time.
> Any ideas?
> Kevin Bond
