MSSQL Selection
MS SQL stands for Microsoft SQL Server. MSSQL is a high performance database which can be used in place of Access databases for your websites. MS SQL Server databases also can be used in your ASP/Perl/iHTML scripts through the use of an ODBC DSN or DSN-less datasource.
MySQL is most commonly used as a Web application alternative to proprietary database systems because of its speed and reliability. MySQL can run on UNIX, Windows and Macintosh operating systems.When working with data that require manipulation, a database makes accessing and manipulating the data easier.It supports Transact-SQL (T-SQL), which is a superset of SQL (Structured Query Language), the most common database language. T-SQL adds additional syntax for use in stored procedures and affects the syntax of transactions support.
MSSQL is used for small-to-medium sized databases as well as large enterprise databases..It is the example of database. Basically, MS SQL Server is much less expensive than other both in upfront costs, and in maintenance. But it only runs on MS. So if you are in a multi-platform environment, it may not be the best choice. However, MS does have drivers for various flavors of *nix,including a JDBC driver for Solaris, so this may not be an issue.
