摘要
Case函数是SQL Server数据库核心语言Transact-SQL语言的重要组成部分,Case函数的表达式有简单Case和搜索Case两种。Case函数可以在SELECT、UPDATE等语句中以及ORDER BY和HAVING等子句中使用,灵活使用case函数可以实现分组、统计等功能。
Case function is an important part of SQL Server database kernel language Transact-SQL language, Case function expression has simple Case and search Case two kinds. Case functions can be used in statements such as SELECT and UPDATE, as well as in ORDER BY and HAVING sub sentences. The flexible use of case functions can implement the functions of grouping, statistics, and so on.
作者
郭翠
Guo Cui(Guangdong Lingnan Industry and Commerce First Technician College, Guangzhou Guangdong 510800, China)
出处
《信息与电脑》
2018年第9期74-76,共3页
Information & Computer
