COLLATION

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Anantheswar G » COLLATION

16 posts, Page 2 of 2

««1 2

COLLATION

Rate Topic

Display Mode

Topic Options

Author

Message

cengland0

Posted Wednesday, November 03, 2010 9:50 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299

Michael Poppers (11/3/2010)

Yes, he might have been better off listing the possible choice as

SELECT CONVERT(char, SERVERPROPERTY('collation','MyDatabaseName'))

and perhaps that was his intention Smile

Agreed. I work in a training organization and consider myself a quiz expert. Writing many quiz applications and writing the actual quizzes too. I can say with 100% certainty that it was a bad distractor because anyone that knows how to use the convert command would know that you don't put the Database name as the second parameter. You can then remove that possible answer as one that you should select.

It could have been offered as

SELECT SERVERPROPERTY('collation','MyDatabaseName')

and just leave off the Convert portion.

Post #1015374

SanDroid

Posted Wednesday, November 03, 2010 10:20 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046

Michael Poppers (11/3/2010)

[quote] and perhaps that was his intention Smile

Good point. It could have been his attention from the start.

It would not be the first time the QOTD was differant from what the Author thought he had posted.

Post #1015404

Sean Lange

Posted Wednesday, November 03, 2010 10:39 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 3:12 PM
Points: 8,957, Visits: 8,523

I will jump on the bandwagon of not getting the convert to char but will point out that I never like code that just uses the default size for datatypes. I don't like to have to stop and think (or more likely lookup) what the default size is for a given datatype.

This is so much easier to read exactly what is being returned:

SELECT CONVERT(char(30), DATABASEPROPERTYEX('AdevntureWorks', 'Collation'))

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1015416