The COLLATE clause can be applied only for the char, varchar, text, nchar, nvarchar, and ntext data types. COLLATE uses collate_name to refer to the name of either the SQL Server collation or the Windows collation to be applied to the expression, column definition, or database definition.
A first in the world of sports. Home to the Arizona Cardinals football team and the annual Fiesta Bowl, the 63,400 seat stadium boasts the first fully retractable natural grass playing field in North America, as well as a retractable roof.
All of the additions to Kauffman Stadium did result in one ironic subtraction, as over 2,500 seats were removed during renovations, reducing the ballparks capacity from 40,775 to 38,177, although all of those seats are rarely called into duty in one night.