beginning microsofl sql server 2008 programming phần 10

bạn sự lựa chọn theo ngữ cảnh có liên quan đến các nguồn dữ liệu đặc biệt OLE DB bạn đang sử dụng. Trong ví dụ trước, tôi đã chỉ đơn giản là nhấp vào "tên cột trong hàng dữ liệu đầu tiên" tùy chọn, và đó là thời gian để nhấn Next một lần nữa. | Appendix A System Functions FILEGROUP_ID The FILEGROUP_ID function returns the filegroup ID number for the specified filegroup name. The syntax is as follows FILEGROUP_ID fiYegroup name The filegroup_name parameter specifies the filegroup name of the required filegroup ID. FILEGROUP_NAME The FILEGROUP_NAME function returns the filegroup name for the specified filegroup ID number. The syntax is as follows FILEGROUP_NAME fnegroup id The filegroup_id parameter specifies the filegroup ID of the required filegroup name. FILEGROUPPROPERTY The FILEGROUPPROPERTY returns the setting of a specified filegroup property given the filegroup and property name. The syntax is as follows FILEGROUPPROPERTY fiPegroụp name property The filegroup_name parameter specifies the name of the filegroup that contains the property being queried. The property parameter specifies the property being queried and can be one of the following values IsReadOnly The filegroup name is read-only. IsUserDefinedFG The filegroup name is a user-defined filegroup. IsDefault The filegroup name is the default filegroup. The return value from this function will be 1 for True 0 for False and NULL if the input was not valid. FILEPROPERTY The FILEPROPERTY function returns the setting of a specified filename property given the filename and property name. The syntax is as follows FILEPROPERTY fiYe_name property The file_name parameter specifies the name of the filegroup that contains the property being queried. The property parameter specifies the property being queried and can be one of the following values IsReadOnly The file is read-only. IsPrimaryFile The file is the primary file. 620 Apendix A System Functions IsLogFile The file is a log file. SpaceUsed The amount of space used by the specified file. The return value from this function will be 1 for True 0 for False and NULL if the input was not valid except for SpaceUsed which will return the number of pages allocated in the file . FULLTEXTCATALOGPROPERTY The .