SQL FAQ
1. What is SQL?
SQL stands for Structured Query Language.
2. Why should I use SQL?
The technology behind SQL makes it far superior compared to traditional
databases such as Access, Paradox, FoxPro, etc. SQL is faster, more
powerful and is very fault tolerant.
3. How do I access/transfer data from an SQL database?
Connecting to an SQL database can be accomplished through many means.
You can use an ODBC connection to make applications like Microsoft
Access or Visual Inderdev directly connect to your SQL database. However,
if you want total control over all the aspects of your database, it
is recommended that you use SQL Enterprise Manager or a Transact-SQL
Client application such as SQL Query.
4. Is it possible to make web sites that interact with
an SQL database?
Yes, this can also be accomplished through different technologies.
The typical method of doing this is by using Scripting Languages such
as Active Server Pages (ASP). These languages have the built in capability
to execute SQL statements that can interact and even modify SQL databases.
Some advanced applications like Visual Inderdev and Frontpage 2000
also have the capability to easily create Web pages that interact
with SQL databases. Using applications such as these makes things
a lot easier for novices or people under time constraints.
5. How do I get SQL for my account?
Contact ETI's support team so that our technicians will be able to
setup your SQL account with the necessary parameters.
6. What are usage limits on my SQL account?
Your SQL disk usage will be included in your total allowable disk
usage for your account. So for example, if you have a Level 3 Hosting
Account ( which allocates 200 MB of disk usage ) and you use 50 MB
of disk usage on your SQL account, that leaves you 150 MB of disk
usage for your Web site or other options before going over your plan.
7. How can I upgrade my Access database to a SQL database?
Please read the online tutorial on using the Access Upsizing Wizard
|