|
 |
asp_web_howto thread: creating tables
Message #1 by "Monique Angelich" <mangelich@m...> on Tue, 18 Sep 2001 06:12:16 -0400
|
|
I know it is possible to create tables by calling a SQL command, but I don't
know if it can be done from SQL? I am also not sure of the correct syntax
for creating a table?
Moe
Message #2 by "Monique Angelich" <mangelich@m...> on Tue, 18 Sep 2001 08:24:00 -0400
|
|
I answered my own question, but now I have a NEW one...
I used to use Visual Basic to control and admin my databases, but I don't
have it now. (used it when I was employed)
Is there a cheaper alternative? I cannot find SQL Manager anywhere.. (query
analyzer, etc) .. please help! I need to get this project going, and the
database is integral!
Moe
----- Original Message -----
From: "Monique Angelich" <mangelich@m...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Tuesday, September 18, 2001 6:12 AM
Subject: [asp_web_howto] creating tables
> I know it is possible to create tables by calling a SQL command, but I
don't
> know if it can be done from SQL? I am also not sure of the correct syntax
> for creating a table?
>
> Moe
Message #3 by "Tim Morford" <tmorford@n...> on Tue, 18 Sep 2001 08:34:28 -0400
|
|
You Can create All most all the Function you need in a ASP based Admin, Or
depending on the DB you can connect Directly to it and run what you need
from there, SQL = Enterprise Manager Access = well Access, MYSQL = Command
Line, Ect..
Tim Morford
-----Original Message-----
From: Monique Angelich [mailto:mangelich@m...]
Sent: Tuesday, September 18, 2001 8:24 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: creating tables
I answered my own question, but now I have a NEW one...
I used to use Visual Basic to control and admin my databases, but I don't
have it now. (used it when I was employed)
Is there a cheaper alternative? I cannot find SQL Manager anywhere.. (query
analyzer, etc) .. please help! I need to get this project going, and the
database is integral!
Moe
----- Original Message -----
From: "Monique Angelich" <mangelich@m...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Tuesday, September 18, 2001 6:12 AM
Subject: [asp_web_howto] creating tables
> I know it is possible to create tables by calling a SQL command, but I
don't
> know if it can be done from SQL? I am also not sure of the correct syntax
> for creating a table?
>
> Moe
Message #4 by "Walter Franssen" <walter@w...> on Tue, 18 Sep 2001 13:48:23
|
|
Use the tool were you can input a query
Message #5 by "Monique Angelich" <mangelich@m...> on Tue, 18 Sep 2001 08:58:20 -0400
|
|
I would like to connect directly to the database, but am not sure what tool
I can use to accomplish this? I have used three in my career.. interdev
(expensive), VisBasic6 (expensive) and Sql Manager.. dunno if that one is
expensive.
Asp based admin?? like response.writing all my query results?
Moe
----- Original Message -----
From: "Tim Morford" <tmorford@n...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Tuesday, September 18, 2001 8:34 AM
Subject: [asp_web_howto] Re: creating tables
> You Can create All most all the Function you need in a ASP based Admin, Or
> depending on the DB you can connect Directly to it and run what you need
> from there, SQL = Enterprise Manager Access = well Access, MYSQL = Command
> Line, Ect..
>
> Tim Morford
>
> -----Original Message-----
> From: Monique Angelich [mailto:mangelich@m...]
> Sent: Tuesday, September 18, 2001 8:24 AM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Re: creating tables
>
>
> I answered my own question, but now I have a NEW one...
>
> I used to use Visual Basic to control and admin my databases, but I don't
> have it now. (used it when I was employed)
>
> Is there a cheaper alternative? I cannot find SQL Manager anywhere..
(query
> analyzer, etc) .. please help! I need to get this project going, and the
> database is integral!
>
> Moe
> ----- Original Message -----
> From: "Monique Angelich" <mangelich@m...>
> To: "ASP Web HowTo" <asp_web_howto@p...>
> Sent: Tuesday, September 18, 2001 6:12 AM
> Subject: [asp_web_howto] creating tables
>
>
> > I know it is possible to create tables by calling a SQL command, but I
> don't
> > know if it can be done from SQL? I am also not sure of the correct
syntax
> > for creating a table?
> >
> > Moe
Message #6 by "Tim Morford" <tmorford@n...> on Tue, 18 Sep 2001 09:18:05 -0400
|
|
Here are a couple of links that might help, But I have used in the past
basic textarea's and then linking them to tables to test queries, and I seem
to remeber that Microsoft Office has a query analyzer in it, called
Msqry32.exe. that might help some also.
http://msdn.microsoft.com/code/default.asp?url=/code/sample.asp?url=/msdn-fi
les/026/002/458/msdncompositedoc.xml
http://www.microsoft.com/sql/evaluation/trial/2000/default.asp
Tim Morford
Message #7 by "Morgan, Rob" <Rob.Morgan@o...> on Tue, 18 Sep 2001 09:17:59 -0400
|
|
I'm using a tool I found on the internet called AQT Advanced Query Tool.
You can find information on it at http://www.querytool.com. Advanced Query
Tool is a simple and fast database query utility, designed for the database
developer and DBA. It works with any ODBC database but designed particularly
for Oracle, DB2, Sybase, MS SQL Server, Informix, MySQL and SQLBase. I use
it for Oracle and Sql Server. I think the free version only allow 50 records
to be viewed at a time.
-----Original Message-----
From: Monique Angelich [mailto:mangelich@m...]
Sent: Tuesday, September 18, 2001 8:58 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: creating tables
I would like to connect directly to the database, but am not sure what tool
I can use to accomplish this? I have used three in my career.. interdev
(expensive), VisBasic6 (expensive) and Sql Manager.. dunno if that one is
expensive.
Asp based admin?? like response.writing all my query results?
Moe
----- Original Message -----
From: "Tim Morford" <tmorford@n...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Tuesday, September 18, 2001 8:34 AM
Subject: [asp_web_howto] Re: creating tables
> You Can create All most all the Function you need in a ASP based Admin, Or
> depending on the DB you can connect Directly to it and run what you need
> from there, SQL = Enterprise Manager Access = well Access, MYSQL = Command
> Line, Ect..
>
> Tim Morford
>
> -----Original Message-----
> From: Monique Angelich [mailto:mangelich@m...]
> Sent: Tuesday, September 18, 2001 8:24 AM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Re: creating tables
>
>
> I answered my own question, but now I have a NEW one...
>
> I used to use Visual Basic to control and admin my databases, but I don't
> have it now. (used it when I was employed)
>
> Is there a cheaper alternative? I cannot find SQL Manager anywhere..
(query
> analyzer, etc) .. please help! I need to get this project going, and the
> database is integral!
>
> Moe
> ----- Original Message -----
> From: "Monique Angelich" <mangelich@m...>
> To: "ASP Web HowTo" <asp_web_howto@p...>
> Sent: Tuesday, September 18, 2001 6:12 AM
> Subject: [asp_web_howto] creating tables
>
>
> > I know it is possible to create tables by calling a SQL command, but I
> don't
> > know if it can be done from SQL? I am also not sure of the correct
syntax
> > for creating a table?
> >
> > Moe
Message #8 by "Monique Angelich" <mangelich@m...> on Sat, 22 Sep 2001 20:52:18 -0400
|
|
I am trying and trying to use AQT to connect to a database I KNOW is
working... and I just can't get it found.
Any suggestions?
I have all the correct info for it.. I know what I am entering is right..
but am I entering it in the wrong places?? HELP??!!
Moe
----- Original Message -----
From: "Morgan, Rob" <Rob.Morgan@o...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Tuesday, September 18, 2001 9:17 AM
Subject: [asp_web_howto] Re: creating tables
> I'm using a tool I found on the internet called AQT Advanced Query Tool.
> You can find information on it at http://www.querytool.com. Advanced
Query
> Tool is a simple and fast database query utility, designed for the
database
> developer and DBA. It works with any ODBC database but designed
particularly
> for Oracle, DB2, Sybase, MS SQL Server, Informix, MySQL and SQLBase. I
use
> it for Oracle and Sql Server. I think the free version only allow 50
records
> to be viewed at a time.
>
>
|
|
|
View Cart
