For a multistatement scalar function , the function body , defined in a begin . end block , contains a series of transact - sql statements that return the single value 对于多语句标量函数，定义在begin . . . end块中的函数体包含一系列返回单个值的transact - sql语句。
In sql server 2005 , the data types that are allowed for parameters and return values in scalar functions and table - valued functions include most lob data types 在sql server 2005中，允许用于标量函数和表值函数的参数和返回值的数据类型包括大多数lob数据类型。
Grants permissions on a table , view , table - valued function , stored procedure , extended stored procedure , scalar function , aggregate function , service queue , or synonym 授予对表、视图、表值函数、存储过程、扩展存储过程、标量函数、聚合函数、服务队列或同义词的权限。
Revokes permissions on a table , view , table - valued function , stored procedure , extended stored procedure , scalar function , aggregate function , service queue , or synonym 撤消对表、视图、表值函数、存储过程、扩展存储过程、标量函数、聚合函数、服务队列或同义词的权限。
Appears in the context of a transact - sql stored procedure , scalar function , multistatement table - valued function , or transact - sql dml trigger in the current database 出现在当前数据库内的transact - sql存储过程、标量函数、多语句表值函数或transact - sql dml触发器的上下文中。
These are the members of the object class : tables , views , table - valued functions , stored procedures , extended stored procedures , scalar functions , aggregate functions , service queues , and synonyms Object类的成员包括：表、视图、表值函数、存储过程、扩展存储过程、标量函数、聚合函数、服务队列以及同义词。
Shows how to debug various kinds of clr database objects : stored procedures , triggers , user - defined scalar functions , user - defined table - valued functions , user - defined aggregates , and user - defined types 演示如何调试各种clr数据库对象：存储过程、触发器、用户定义的标量函数、用户定义的表值函数、用户定义的聚合和用户定义的类型。
For sql server users and application developers , clr integration means that you can now write stored procedures , triggers , user - defined types , user - defined functions scalar and table - valued , and user - defined aggregate functions using any . net framework language , including microsoft visual basic and microsoft visual c 对于sql server用户和应用程序开发人员来说， clr集成意味着您现在可以使用任何. net framework语言（包括microsoft visual basic和microsoft visual c ）编写存储过程、触发器、用户定义类型、用户定义函数（标量函数和表值函数）以及用户定义的聚合函数。
This statement can be used to deny permissions on certain stored procedures , extended stored procedures , table - valued functions , scalar functions , views , catalog views , compatibility views , information schema views , dynamic management views , and system tables that are installed by sql server 2005 可使用该语句拒绝对sql server 2005安装的特定存储过程、扩展存储过程、表值函数、标量函数、视图、目录视图、兼容性视图、 information _ schema视图、动态管理视图以及系统表的权限。
For example , if i wish to add a scalar function that returns the crc32 checksum of a string column , i have to create a class containing a public static method , as shown in listing 1 , and then it ll be available for use on sql statements after the script in listing 2 is executed 例如，如果我希望添加一个标量函数，以返回一个字符串列的crc32检验和，我不得不创建一个包含有public static方法的类，如清单1所示，然后，当清单2中的脚本执行以后，它就可以被sql语句所使用了。
