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语句所使用了。
This statement can be used to revoke 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视图、动态管理视图以及系统表的权限。
This statement can be used to grant 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视图、动态管理视图以及系统表的权限。