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.
It will also be bigger than Texas' Darrell K. Royal Stadium, which only seats 100,119, another way for the Aggies to one-up the Longhorns. Of course, capacity isn't much of an issue for Aggies fans, who have crammed as many as 90,000 in Kyle Field's current capacity.