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 1, 2009 11:10 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Comments posted to this topic are about the item Data Types

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

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, December 11, 2014 5:11 AM
Points: 654, Visits: 267
Easy one!
Post #781325
Posted Wednesday, September 2, 2009 5:17 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
It's a fairly easy question, but so far 27% have missed it

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

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

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

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, November 9, 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 2, 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: Monday, December 22, 2014 11:01 AM
Points: 3,221, Visits: 2,376
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 2, 2009 1:04 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 9:27 AM
Points: 169, Visits: 106
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 2, 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: Monday, December 22, 2014 11:01 AM
Points: 3,221, Visits: 2,376
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 2, 2009 1:33 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 9:27 AM
Points: 169, Visits: 106
So true!


Post #781777
Posted Friday, March 23, 2012 3:39 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: Yesterday @ 2:31 PM
Points: 3,128, Visits: 3,250
I like your question. Thanks. My learning is growing very fast with this community.




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1272146
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse