Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Is it possible/effective to create an entire SQL DB from ASP?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-10 : 14:51:38
Dave writes "I would like to begin using MS SQL 7. I can't afford to buy the server or InterDev 6.0 right now. Is it possible/effective to create all of the tables and columns that I need using ASP?

My host will create an empty DB.

Also... Am I correct in my understanding of SQL in that data is stored in groups (tables)and that the columns are the individual variables in that group?

I.E. Table 1 "Employees"
Column 1 "strName"
Column 2 "strAddress"

Table 2 "Products"
Column 1 "productID"
Column 2 "crPrice"
Column 3 "numInStock"

Is this correct? I would need 15-20 Access db's... If I could combine it into one SQL db it would be better.

[ummm, I have Win ME installed - hope to move to NT or 2000 soon, in case you need to know]"
   

- Advertisement -