SQL Server数据库字段连接及其简化技巧  

Techniques of SQL Server Database Field Connection and Simplification

作　　者：庹超[1] 

机构地区：[1]华中科技大学,武汉430074

出　　处：《电脑编程技巧与维护》2013年第12期31-33,共3页Computer Programming Skills & Maintenance

摘　　要：关系数据库在当前信息化进程中占据着重要地位。在管理SQL Server数据库的过程中,数据库管理员需要更新数据库字段,根据某一字段进行分类统计,经常会对字段进行连接处理。字段连接分为两类:对同一记录的不同字段连接;对具有相同特定字段的记录的其他字段进行连接处理。不管是哪种情况,总是可以使用SQL语句、数据库函数及游标来实现。At present, relational database still occupies an important role In the process of informatization. During the management of SQL Server database, administrators need to update database fields, and frequently they make the joint of fields to classify according to a certain field. The joints are made in two cases. Connection of different fields in the same record is the first. And another one is connection of different fields in different records which possess a given field attribute. Whatever the case, the joint could be realized by SQL statements, database functions and cursors.

关 键 词：关系数据库 字段连接 SQL数据库 函数 游标 

分 类 号：TP311.138[自动化与计算机技术—计算机软件与理论]