Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Question of the Day for 25 Aug 2005 Expand / Collapse
Author
Message
Posted Thursday, August 25, 2005 8:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 8:53 PM
Points: 154, Visits: 78
Being the "low on attention to detail" person I am, I would have certainly missed this one if 11 was one of the choices.  Good...I get 21 points
Post #213903
Posted Thursday, August 25, 2005 4:54 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, April 13, 2009 11:58 AM
Points: 375, Visits: 5

*LOL*  maybe it was worth 21 points because it WAS a trick question.

Although I'm pretty suspicious every time I come to answer a qod.  Every so often they put something in that you have to be paying attention to catch *L*




aka "Paul"
Non est ei similis.

Any man who can drive safely while kissing a pretty girl is simply not giving the kiss the attention it deserves. ~ Albert Einstein
Post #214167
Posted Friday, August 26, 2005 7:50 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 4, 2012 9:22 PM
Points: 102, Visits: 9

Try this:

DECLARE @val CHAR(20), @v2 CHAR(40)
select LEN(@val), LEN(@v2)
SET @val = ' SSC is cool '
SET @v2 = @val + @val
select LEN(@val), LEN(@v2)

And this, for a different, non-intuitive result:

DECLARE @val nvarchar(20), @v2 nvarchar(40)
select LEN(@val), LEN(@v2)
SET @val = ' SSC is cool '
SET @v2 = @val + @val
select LEN(@val), LEN(@v2)

Regards, BobM




Regards,

Bob Monahon
Post #214355
Posted Friday, August 26, 2005 7:54 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:48 AM
Points: 21,388, Visits: 9,604
Now THAT would be a trick question .
Post #214360
Posted Friday, December 11, 2009 12:10 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:07 PM
Points: 21,351, Visits: 15,032
Nice. Just stumbled onto this little pot of gold.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #832740
Posted Thursday, November 8, 2012 2:55 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:34 AM
Points: 1,888, Visits: 2,326
Its not a question that worth of 21 points...



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1382353
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse