What is the syntax of the COLLATE clause?

August 21st, 2009 by uCertify Leave a reply »

The syntax of the COLLATE clause is as follows:

COLLATE (<collation_name> | current_database_name)

Here, the <collation_name> argument is used to specify the collation for a database or a column. The collation name can be either a Windows collation name or a SQL Server collation name.

The <current_database_name> argument is used to inherit the collation of the current database.

Download free practice test for Microsoft MCITP Microsoft SQL Server exam. Click here to download 70-441 test study guide and practice question.
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark
Advertisement

Leave a Reply

uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.