摘要
结构化查询语言SQL是高级的非过程化编程语言,在其他编程语言中需要用一大段程序才可实践的一个单独事件,而其在SQL上只需要一个语句就可以被表达出来。广东电网有限责任公司汕尾供电局建立的班组考勤系统使用SQL Server数据库,监察部需要抽查员工所有签到和未签到记录。通过构造SQL查询语句,一次性选择出所有指定记录。
The structured query language SQL is a high-level non-procedural programming language. A single event that requires a large number of programs to practice in other programming languages, It can be expressed in only one statement on the SQL. The team attendance system established by our bureau uses SQL Server database. The supervision department needs to check all the employee’s sign-in and non-sign-in records on a spot-check basis. By constructing an SQL query, all the specified records are selected at once.
作者
王冲
Wang Chong(Guangdong Power Grid Co., Ltd., Shanwei Power supply Bureau, Shanwei Guangdong 516600, China)
出处
《信息与电脑》
2018年第23期38-39,42,共3页
Information & Computer