tailieunhanh - wrox beginning sql server 2005 programming phần 10

Các tham số kiểu xác định tên của các kiểu dữ liệu. Tham số tài sản quy định cụ thể tài sản của các kiểu dữ liệu được truy vấn, nó có thể là một trong những giá trị sau: Đối chiếu của các giá trị sql_variant cụ thể. Các loại dữ liệu tối đa chiều dài, trong byte. | Appendix B Value Description Base type of sql_variant returned ỉimpo PDFcMerge andiSplitnUn registeredVers lonit-Mtp the numeric base datatype decimal p s and numeric p s s money and smallmoney 4 datetime 3 all other types 0 TotalBytes The number of bytes required to hold both the int meta data and data of the value. If the value is greater than 900 index creation will fail. Collation The collation of the particular sql_variant value. sysname MaxLength The maximum data type length in bytes. int TYPEPROPERTY The TYPEPROPERTY function returns information about a datatype. The syntax is as follows TYPEPROPERTY type property The type parameter specifies the name of the data type. The property parameter specifies the property of the datatype that is to be queried it can be one of the following values Precision Returns the number of digits characters Scale Returns the number of decimal places AllowsNull Returns 1 for True and 0 for False UsesAnsiTrim Returns 1 for True and 0 for False Rowset Functions The rowset functions return an object that can be used in place of a table reference in a T-SQL statement. The rowset functions are CONTAINSTABLE FREETEXTTABLE OPENDATASOURCE OPENQUERY OPENROWSET OPENXML 618 System Functions CONTAINSTABLE The CONTAINSTABLE function is used in full-text queries. Please refer to Chapter 26 for an example of its iimpo PDF MergeandS plit Unregistered Version - http CONTAINSTABLE table column contains_search_condition FREETEXTTABLE The FREETEXTTABLE function is used in full-text queries. Please refer to Chapter 26 for an example of its usage. The syntax is as follows FREETEXTTABLE table column freetext_string OPENDATASOURCE The OPENDATASOURCE function provides ad hoc connection information. The syntax is as follows OPENDATASOURCE provider_name init_string The provider_name is the name registered as the ProgID of the OLE DB provider used to access the data source. The init_string should be familiar to VB .