server| Server | data | database | Server Microsoft SQL Server is a relational database, it is a perfect client/server system. SQL Server needs to be installed on a Windows NT platform, while Windows NT can support platforms such as Intel 386,power Pc,mips,alpha PCs and RISC, which gives SQL Server sufficient power and functionality.
The database applications used in all of the articles here are based on SQL Server, ODBC and standard SQL queries can be easily ported to any ODBC-enabled database, such as ORACLE,INFORMIX,DB2 and access, Before you read about ASP database programming techniques, make sure that you are at least familiar with a database management system and that you can manipulate the database using standard SQL query language.
SQL Server provides server-side software, which needs to be installed on NT Server, and SQL Server's client can be installed on many client-side PC systems, Windows allows the client to build, maintain and Access databases, SQL Server can define up to 32,767 databases, each database can define 2 billion tables, each table can have 250 fields, the number of data per table is not limited, each table can define 250 indexes, one of which can be clustered index.
SQL Server uses the database query language known as Transact-SQL, which is the core of the SQL Server, and Transact-SQL strengthens the original keywords for data access, storage and processing functions, Transact-SQL expands Process Control designation to make it easy for you to write powerful stored procedures that are stored on the server side and precompiled, execute very fast, trigger is a special stored procedure to ensure the integrity of SQL Server database references, you can create inserts, Delete and update triggers to control the insertion, deletion, and updating of data columns in the relevant tables, and you can also use rules, defaults (default), and Restrictions (Constraints) to help apply the new values to the table!
On the issue of SQL Server, this site has set up a special topic, please go to the SQL Server topics to learn more!
This article by the Beach Boy finishing production, you can reprint, but please specify its origin, thank you!
