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.
Busch Stadium. On April 10, 2006, the Cardinals opened their new 46,000 seat retro-style downtown ballpark with a 6-4 win over the Milwaukee Brewers. The Cardinals also became the first team in almost 100 years to win a World Series Championship in the inaugural season of a new ballpark. The new Busch Stadium hosted the 80th MLB All-Star Game, in July 2009.