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

Why it is returning * Expand / Collapse
Author
Message
Posted Thursday, September 20, 2012 1:06 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:34 AM
Points: 88, Visits: 286
hi All,

when i am executing the below query it is returning * instead of showing error.

select cast(123 as varchar(2))

means the length of the integer value is greater than the converting value that time it is showing the result.

thanks,
Post #1361763
Posted Thursday, September 20, 2012 1:41 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 9:12 AM
Points: 1,483, Visits: 8,552
Documented behaviour - http://msdn.microsoft.com/en-us/library/aa226054(v=sql.80).aspx#feedback, half-way down the article.

BrainDonor
Linkedin
Blog Site
Post #1361772
Posted Thursday, September 20, 2012 3:59 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:34 AM
Points: 88, Visits: 286
Thank you very much
Post #1361832
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse