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 123»»»

Printing Lengths Expand / Collapse
Author
Message
Posted Saturday, December 11, 2010 1:02 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, October 11, 2013 3:27 PM
Points: 127, Visits: 132
Comments posted to this topic are about the item Printing Lengths

Rahul
Post #1033369
Posted Sunday, December 12, 2010 4:00 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, October 11, 2013 3:27 PM
Points: 127, Visits: 132
Hi,
All my drear readers hope you will be able to learn a trick about varchar and char datatypes in SQL.
Thanks for viewing it.....


Rahul
Post #1033449
Posted Sunday, December 12, 2010 5:05 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:51 AM
Points: 5,587, Visits: 24,942
Rahul The Dba (12/12/2010)
Hi,
All my drear readers hope you will be able to learn a trick about varchar and char datatypes in SQL.
Thanks for viewing it.....


I did and thanks for posting ... was/is a good question


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1033532
Posted Sunday, December 12, 2010 7:22 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 11:58 AM
Points: 8,687, Visits: 9,221
Good question. Not sure how I managed to get it wrong, because it's prety straightforward.


Tom
Post #1033547
Posted Sunday, December 12, 2010 11:49 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, October 11, 2013 3:27 PM
Points: 127, Visits: 132
Thanks..

Rahul
Post #1033600
Posted Monday, December 13, 2010 4:11 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 4:28 AM
Points: 1,100, Visits: 4,898
Thanks for a good question - I hadn't realised there would be a scope problem in this instance so I learnt something new today
Post #1033687
Posted Monday, December 13, 2010 4:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 15, 2011 3:08 PM
Points: 12, Visits: 22
Thanks a lot for your good question!
and i did it right!
Post #1033688
Posted Monday, December 13, 2010 5:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 13,570, Visits: 10,447
Nice question, although I believe I've seen similar around here (but hey, it can't hurt to refresh things from time to time).
Some reference links would have been nice for those who would've wanted to read up on the subject.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1033721
Posted Monday, December 13, 2010 7:00 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:39 AM
Points: 2,818, Visits: 2,558
Inconsistent behavior of SQL Server on the default length. I learned something today. Thanks.
Post #1033774
Posted Monday, December 13, 2010 7:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 2,349, Visits: 2,694
Good question. Taught me something I need to learn.

Thanks,
webrunner


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #1033790
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse