Microsoft's SQL Server is a relational database and is a perfect customer/Server system. SQL Server must be installed on the Windows NT platform, while Windows NT can support Intel 386, Power PC, MIPS, Alpha PC, and other platforms, it gives SQL Server enough power and functionality.
The database applications used in all the articles here are based on SQL Server. Using ODBC and standard SQL queries can be easily transplanted to any database that supports ODBC, for example: Oracle, Informix, Db2, and Access. Before reading ASP database programming technology, make sure you are familiar with at least one database management system, you can also operate databases using standard SQL query languages.
SQL Server provides software for the Server. This part needs to be installed on the NT Server. The SQL Server client can be installed in many client PC systems. Windows allows the user to establish databases, for maintenance and access operations, SQL Server can define up to 32767 databases. In each database, 2 billion tables can be defined, and each table can have 250 fields, there is no limit on the number of data in each table. Each table can define 250 indexes, one of which can be a Clustered index.
The database query language used by SQL Server is called Transact-SQL. It is the core of SQL Server. Transact-SQL enhances the original SQL keywords for data access, storage, and processing functions, transact-SQL expands the process control designation, allowing you to easily write powerful stored procedures, which are stored on the server side and compiled in advance, with extremely fast execution speed, trigger is a special stored procedure used to ensure the integrity of SQL Server database references. You can create insert, delete, and update triggers to control the insertion of data columns in related tables, you can also use rules (Rule), default, and Constraints to apply new values to tables!
For SQL Server problems, this site has set up a special topic. Please go to the SQL Server topic to learn more!
This article is prepared by the beach kiddies. You can repost it, but please indicate its source. Thank you!
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
