T-SQL Logic

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 Henrico Bekker » T-SQL Logic

23 posts, Page 3 of 3

«««1 2 3

T-SQL Logic

Rate Topic

Display Mode

Topic Options

Author

Message

Grumpy DBA

Posted Friday, June 25, 2010 1:53 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, May 13, 2013 7:38 AM
Points: 4,149, Visits: 611

Huh... I thought I chose "1" but it says I answered the question wrong... what's up with that?

Post #943323

Wayne Evans-440401

Posted Monday, June 28, 2010 5:49 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:28 PM
Points: 108, Visits: 216

Interesting one. The explanation given isn't quite correct:

2. len(case name when 'master' then 'other' else 'name' end) > 4 --only the length of 'master' > 4, all other db's are changed to 'name', which length =4.

its not the len of the word 'master' being compaired, but the lenth of the word 'other'.

Wayne

Did you get access denied? Great the security works.

Post #943815

ken.trock

Posted Wednesday, June 30, 2010 2:07 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 2:51 PM
Points: 315, Visits: 1,356

Take out "and database_id < 2"; you still get the same result and looks like a harder question.

Ken

Post #945772

« Prev Topic | Next Topic »

23 posts, Page 3 of 3

«««1 2 3

Permissions