SQL SERVER隐藏系统函数sp_columns_100_rowset和sp_table_statistics2_rowset

今天突然发现2个隐藏系统函数sp_columns_100_rowset和sp_table_statistics2_rowset

sp_columns_100_rowset定义如下：

  

create procedure sys.sp_columns_100_rowset  

(  

    @table_name     sysname = NULL,  

    @table_schema   sysname = NULL,  

    @column_name    sysname = NULL  

)  

as  

    select  

        TABLE_CATALOG           = s_cv.TABLE_CATALOG,  

        TABLE_SCHEMA            = s_cv.TABLE_SCHEMA,  

        TABLE_NAME              = s_cv.TABLE_NAME,  

        COLUMN_NAME             = s_cv.COLUMN_NAME,  

        COLUMN_GUID             = s_cv.COLUMN_GUID,  

        COLUMN_PROPID           = s_cv.COLUMN_PROPID,  

        ORDINAL_POSITION        = s_cv.ORDINAL_POSITION,  

        COLUMN_HASDEFAULT       = s_cv.COLUMN_HASDEFAULT,  

        COLUMN_DEFAULT          = s_cv.COLUMN_DEFAULT,  

        COLUMN_FLAGS            = s_cv.COLUMN_FLAGS,  

        IS_NULLABLE             = s_cv.IS_NULLABLE,  

        DATA_TYPE               = s_cv.DATA_TYPE, -- Used by Katmai+ clients  

        TYPE_GUID               = s_cv.TYPE_GUID,  

        CHARACTER_MAXIMUM_LENGTH= s_cv.CHARACTER_MAXIMUM_LENGTH,  

        CHARACTER_OCTET_LENGTH  = s_cv.CHARACTER_OCTET_LENGTH,  

        NUMERIC_PRECISION       = s_cv.NUMERIC_PRECISION,  

        NUMERIC_SCALE           = s_cv.NUMERIC_SCALE,  

        DATETIME_PRECISION      = s_cv.DATETIME_PRECISION,  

        CHARACTER_SET_CATALOG   = s_cv.CHARACTER_SET_CATALOG,  

        CHARACTER_SET_SCHEMA    = s_cv.CHARACTER_SET_SCHEMA,  

        CHARACTER_SET_NAME      = s_cv.CHARACTER_SET_NAME,  

        COLLATION_CATALOG       = s_cv.COLLATION_CATALOG,  

        COLLATION_SCHEMA        = s_cv.COLLATION_SCHEMA,  

        COLLATION_NAME          = s_cv.COLLATION_NAME,  

        DOMAIN_CATALOG          = s_cv.DOMAIN_CATALOG,  

        DOMAIN_SCHEMA           = s_cv.DOMAIN_SCHEMA,