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.
Microsoft Theater (previously the Nokia Theatre) is a music and theatre venue seating 7,100, while Club Nokia is a club venue with a seating capacity of 2,300 for live music and cultural events.The theatre has hosted the ESPY Awards since 2008. L.A. Live is featured under construction in the 2008 video game Midnight Club: Los Angeles. 2  L.A. Live is the filming location of the grand finals of American Idol. 3  L.A. Live was used as a filming location for Stark Expo 2010 in Iron Man 2.