| SQL Server2005中用触发器实现数据库的数据完整性研究 |
| |
| 引用本文： | 邓有林.SQL Server2005中用触发器实现数据库的数据完整性研究[J].湖南工业职业技术学院学报,2011,11(4):23-25. |
| |
| 作者姓名： | 邓有林 |
| |
| 作者单位： | 保山学院信息学院,云南保山,678000 |
| |
| 摘 要： | 数据库中的数据是从外界输入的,输入后面临修改、删除等操作,由于种种原因,会发生输入无效或错误信息。保证数据库中数据的完整性,成为数据库系统,尤其是多用户的关系数据库系统首要关注的问题。本文介绍了在SQL Server 2005数据库系统中,用触发器实现数据完整性的控制方法,并举例说明触发器的实际应用。
|
| 关 键 词： | SQL Server2005 数据完整性 触发器 |
The Research of the Data Integrity of SQL Server 2005 with Trigger Realize Database |
| |
| DENG You-Lin.The Research of the Data Integrity of SQL Server 2005 with Trigger Realize Database[J].Journal of Hunan Industry Polytechnic,2011,11(4):23-25. |
| |
| Authors: | DENG You-Lin |
| |
| Affiliation: | DENG You-Lin (Baoshan college information institute in baoshan,Baoshan 678000,yunnan) |
| |
| Abstract: | the data in the database from outside of the input,Then it faces after modification and deletion of operation,it will occur input invalid or false information due to various reasons.Ensure the integrity of the data in the database,become a database system,especially many users database system top issue.This paper introduces the SQL Server 2005 database systems,realize the integrity of the data with flip-flop control method,and illustrate the actual application of the trigger. |
| |
| Keywords: | SQL Server 2005 data integrity trigger |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
