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 Administration (2000)
 Adding Fields and Field Types from an ASP Website

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-01 : 08:46:47
Philip writes "A lot of people must be in my situation: they run an ASP website that uses a SQL server database but they do not have the actual program and are only able to run SQL statements from ASP pages. Now my question: Can I add Fields/Tables and set Field Types using SQl statements that I trigger from my ASP pages. If yes, how and what syntax should I be using?

Something like:
ALTER TABLE XXX"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-03-01 : 08:46:47
Yes. You can download Books Online. It will list the syntax of the ALTER TABLE statement. http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

And you can download a demo version of SQL Server from Microsoft. The database will expire but the tools won't. Make your life much easier :)
Go to Top of Page
   

- Advertisement -