MS SQL Server Frequently Asked Questions
- What is SQL?
- SQL stands for Structured Query Language, which is a standard programming language for "talking" to databases.
- Why should I use SQL Server?
- 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.
- 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 MS Access or Visual Inderdev directly connect to your SQL database.
- 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) or ColdFusion. These languages have the built in capability to execute SQL statements that can interact and even modify SQL databases.
Some 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.