The following is part of the code in yesterday’s email article. It goes on to iterate all the database properties:
SELECT
CHAR(10),’collation
‘,DATABASEPROPERTYEX( ‘pubs’ , ‘collation’ ),
CHAR(10),’IsAnsiNullDefault
‘,DATABASEPROPERTYEX( ‘pubs’ , ‘IsAnsiNullDefault’ )
The first three bullets in BOL>index>’select list’ :
“These attributes of the result set columns are defined by the expressions in the select list: ”
1. The data type, size, precision, and scale of the result set column are the same as those of the expression defining the column.
2.The name of the result set column is the name associated with the expression defining the column. The optional AS keyword can be used to change the name, or to assign a name if the expression has no name.
3. The data values for the result set column are derived from the evaluation of the expression for each row of the result set.
The above statement returns an empty column for each iteration of “CHAR(10)” while the first bullet in the BOL (above) implies that the data type can be somehow included in select list column.
Can someone clear this up for me?