Data Type and Length

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by SveG » Data Type and Length

32 posts, Page 2 of 4

««1 2 3 4 »»»

Data Type and Length

Rate Topic

Display Mode

Topic Options

Author

Message

Ameya- Ameyask

Posted Monday, August 09, 2010 4:25 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 18, 2012 4:53 AM
Points: 123, Visits: 28

Very good question indeed. Takes back to basics Smile

Post #965814

Dennissinned

Posted Monday, August 09, 2010 6:45 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 19, 2011 7:26 AM
Points: 1,078, Visits: 289

Great Question. Thank you.

Post #965904

Kari Suresh

Posted Monday, August 09, 2010 7:22 AM

SSC Veteran

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

Good question. Thank you.

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 #965940

Daniel Bowlin

Posted Monday, August 09, 2010 7:43 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:10 PM
Points: 2,673, Visits: 2,418

Curious, the difference in default behaviour between a DECLARE and a CONVERT.

I suppose this just puts another check mark in the Always Declare Everything column.

Post #965950

Sean Lange

Posted Monday, August 09, 2010 8:02 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 1:17 PM
Points: 8,641, Visits: 8,273

Excellent question! I noticed the lack of defining the size and my initial response was 1;1 but since that was not a choice I figured there must be something in convert for default sizes. Had there been an answer of 1;1 I would have assumed that was the correct answer. Wink

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #965968

pjdiller

Posted Monday, August 09, 2010 9:04 AM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:26 AM
Points: 404, Visits: 274

Thanks very much! This is a question that applies to the category of "things I need to know and will probably run across" and the answer is straight-forward/simple! Ok, I got it wrong, but that's because I have plenty to learn.

(The last couple times I've commented, it was due to being frustrated with the question, thought I might add some positive feedback as well Cool

)

Post #966026

Enigma475

Posted Monday, August 09, 2010 3:01 PM

Right there with Babe

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 1:09 PM
Points: 778, Visits: 164

This is a very good question. My initial choice was 3/38. It's a good thing I decided to run the code before answering. I learned something new Smile

...

Post #966260

Kangana Beri

Posted Monday, August 09, 2010 5:56 PM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 10, 2013 3:04 PM
Points: 839, Visits: 938

Good question. Thank you!

Post #966314

David Data

Posted Tuesday, August 10, 2010 1:41 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 3:28 AM
Points: 115, Visits: 719

I got it wrong too. But like many questions here, the answer depends on knowing the many inconsistencies and strange rules in SQL Server - most of which you never need to know.

I had no idea how long char and varchar default sizes are, for the simple reason that I've never declared any without specifying the length. IMHO the correct answer should have been 'Syntax Error'!

It would be nice to have a datatype like .NET's string which can carry strings of (almost) any length without worrying about what its contents' maximum length might happen to be. Fields in database tables may need to be specified precisely; local variables should not.

Post #966974

paul.knibbs

Posted Wednesday, August 11, 2010 1:01 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 1,259, Visits: 4,260

David Data (8/10/2010)
It would be nice to have a datatype like .NET's string which can carry strings of (almost) any length without worrying about what its contents' maximum length might happen to be. Fields in database tables may need to be specified precisely; local variables should not.

Isn't that pretty much what VARCHAR(MAX) is?

Post #967180

« Prev Topic | Next Topic »

32 posts, Page 2 of 4

««1 2 3 4 »»»

Permissions