Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by NT » PRINT vagaries
Add to briefcase
50 posts, Page 1 of 5
12345»»»

PRINT vagaries Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Ol'SureHand
Posted Tuesday, June 29, 2010 9:45 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, May 12, 2013 11:47 PM
Points: 356, Visits: 700
Comments posted to this topic are about the item PRINT vagaries
Post #945180
UMG Developer
Posted Tuesday, June 29, 2010 9:53 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148
Nice question thanks!
Post #945182
Henrico Bekker
Posted Tuesday, June 29, 2010 11:14 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692
Good tricky one...thank you

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #945206
udayroy15
Posted Wednesday, June 30, 2010 12:06 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, February 02, 2013 5:42 AM
Points: 190, Visits: 74
Interesting & tricky!!
Post #945219
Kari Suresh
Posted Wednesday, June 30, 2010 12:13 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 01, 2013 11:12 PM
Points: 248, Visits: 372

Yes.. it is tricky, this query also results the same..

PRINT LEN(@StringArray) + '-' + LEN(@Delimiter)

KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
Post #945221
Atif-ullah Sheikh
Posted Wednesday, June 30, 2010 12:33 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 14, 2013 4:15 AM
Points: 3,240, Visits: 4,960
Good question..

And its because the datatype of the variables ( @lenStringArray and @lenDelimiter) is INT.



----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.

You can check my BLOG here
Post #945226
dgvozdetsky
Posted Wednesday, June 30, 2010 12:35 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 6:06 AM
Points: 1,685, Visits: 90
Good question!!! Thanks!
Post #945228
Christian Buettner-167247
Posted Wednesday, June 30, 2010 12:57 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:36 AM
Points: 2,522, Visits: 3,616
Nice question, but this is not a "PRINT vagary". Instead this is just how type conversion works (http://msdn.microsoft.com/en-us/library/ms190309.aspx).

SELECT @lenStringArray + '-' + @lenDelimiter

behaves the same way, because int (@lenStringArray & @lenDelimiter) has a higher precedence than varchar(1) ('_').

Best Regards,
Chris Büttner
Post #945236
dbuendiab
Posted Wednesday, June 30, 2010 1:29 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 11:41 AM
Points: 77, Visits: 218
I'm surprised but is true:

Select Cast( '+' as int ) --> 0
Select Cast( '-' as int ) --> 0
Post #945256
info 25880
Posted Wednesday, June 30, 2010 2:04 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 23, 2012 5:39 AM
Points: 169, Visits: 49
Yes, that's reason, because the result of an implicit casting of '-' is zero
SELECT 6 + 1 + '-'
Post #945276
« Prev Topic | Next Topic »

Add to briefcase
50 posts, Page 1 of 5
12345»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.