Chapter 4 QUERYING AND MODIFYING DATA 227 System
Chapter 4 QUERYING AND MODIFYING DATA 227 System Functions As you have seen in the previous two compilations, many functions are supplied to perform mathematical and character-manipulation operations. You can also use a third category of functions with the SELECT list known as system-specific functions. You can use system functions to retrieve special system or database information through T-SQL and the SELECT statement. Table 4.10 shows a compilation of the numerous system functions available in T-SQL. TABLE 4.10 DATABASE/SYSTEM FUNCTIONS IN T-SQL System Function Parameters Description COL_LENGTH (table name, The length of a column. column name) COL_NAME (table_id, The name of a column. Column_id) DATALENGTH (Expression) The length of any expression in bytes. DB_ID (database_name) The database s identification number. DB_NAME (database_ID) The database s name. GETANSINULL (database_name) Returns the default nullability for the database for this session. HOST_ID ( ) The identification number for the workstation. HOST_NAME ( ) The name of the workstation. IDENT_INCR (table or view) Returns the increment value specified during the creation of an identity column in a table or view that has an identity column. IDENT_SEED (table or view) The starting number for an identity column. INDEX_COL (table name, index_ The indexed column s name. id,key_id) ISNULL (expression, value) Changes NULL values in the expression to a value specified. continues
If you looking for unlimited one inclusive web hosting plan please check unlimited web hosting website.