<br />Returns a character expression after converting uppercase character data to lowercase.<br />Transact-SQL Syntax ConventionsCopyLOWER (character_expression )<br />Argumentscharacter_expression<br />Is an expression of character or binary data. c

<br />Returns a character expression with lowercase character data converted to uppercase.<br />Transact-SQL Syntax ConventionsCopyUPPER (character_expression )<br />Argumentscharacter_expression<br />Is an expression of character data. character_exp

FORMAT() 函数<br />FORMAT 函数用于对字段的显示进行格式化。SQL FORMAT() 语法SELECT FORMAT(column_name,format) FROM table_name参数描述column_name必需。要格式化的字段。format必需。规定格式。SQL FORMAT() 实例<br />我们拥有下面这个 "Products" 表：Prod_IdProductNameUnitUnitPrice1gold1000 g32.352silver1000 g11.563cop

LIKE 操作符用于在 WHERE 子句中搜索列中的指定模式。LIKE 操作符LIKE 操作符用于在 WHERE 子句中搜索列中的指定模式。SQL LIKE 操作符语法SELECT column_name(s)FROM table_nameWHERE column_name LIKE pattern原始的表 (用在例子中的)：Persons 表:IdLastNameFirstNameAddressCity1AdamsJohnOxford StreetLondon2BushGeorgeFifth Av

AVG (SQL Server Compact Edition)<br /> <br />返回一个组中值的平均值。空值将被忽略。语法复制AVG ( [ ALL ] expression ) <br />参数ALL <br />对所有值应用聚合函数。默认值为 ALL。expression <br />精确数字或近似数字数据类型类别（bit 数据类型）除外的表达式。不允许使用聚合函数和子查询。返回值<br />返回类型由 expression 计算结果的类型确定。表达式结果