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

Data Types Expand / Collapse
Author
Message
Posted Tuesday, September 01, 2009 11:10 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,588, Visits: 247
Comments posted to this topic are about the item Data Types

http://brittcluff.blogspot.com/
Post #781212
Posted Wednesday, September 02, 2009 5:07 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 6:34 AM
Points: 654, Visits: 265
Easy one!
Post #781325
Posted Wednesday, September 02, 2009 5:17 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,588, Visits: 247
It's a fairly easy question, but so far 27% have missed it

http://brittcluff.blogspot.com/
Post #781327
Posted Wednesday, September 02, 2009 6:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, August 01, 2010 1:40 AM
Points: 2, Visits: 2
So easy question.. just for kids..
Post #781349
Posted Wednesday, September 02, 2009 8:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, November 09, 2012 7:25 AM
Points: 298, Visits: 107
Every question's easy if you know the answer. I was surprised at this one, and got it right on the basis I knew one of my colleagues had got it wrong and I could make and educated guess.

I've been writing extensive amounts of TSQL for more years than I care to count and I have never written
 character varying(20) 


in place of
 VARCHAR(20) 


It almost begs the question, why is it not "CHARVAR(20)"

Every day's a school day.
Post #781532
Posted Wednesday, September 02, 2009 11:26 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: Friday, November 22, 2013 11:05 AM
Points: 3,108, Visits: 2,116
Amazing - yet another new thing that I have learned about SQL !!!



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #781659
Posted Wednesday, September 02, 2009 1:04 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, November 07, 2012 12:50 PM
Points: 169, Visits: 93
chriscoates (9/2/2009)
Every question's easy if you know the answer. I was surprised at this one, and got it right on the basis I knew one of my colleagues had got it wrong and I could make and educated guess.

I've been writing extensive amounts of TSQL for more years than I care to count and I have never written
 character varying(20) 


in place of
 VARCHAR(20) 


It almost begs the question, why is it not "CHARVAR(20)"

Every day's a school day.


I guess you never did any coding in COBOL. Character varying is used all over the FD Section.



Post #781746
Posted Wednesday, September 02, 2009 1:21 PM
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: Friday, November 22, 2013 11:05 AM
Points: 3,108, Visits: 2,116
VS COBOL, VS COBOL I, VS COBOL II along with IMS and DB2 ...

all so long ago (after BAL) back in the early and mid eighties ...

age and senility are sometimes close comrades in arms !




Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #781766
Posted Wednesday, September 02, 2009 1:33 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, November 07, 2012 12:50 PM
Points: 169, Visits: 93
So true!


Post #781777
Posted Friday, March 23, 2012 3:39 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:37 AM
Points: 2,729, Visits: 2,648
I like your question. Thanks. My learning is growing very fast with this community.
Post #1272146
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse