The Default Variable String
-
Comments posted to this topic are about the item The Default Variable String
-
Nice one Steve!
😎
I like short questions, with short answers and even shorter query outcome 😉
-
In times past, using varchar without a length defaulted to 30 characters. Did that change?
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com -
I don't think so. I checked back through 2017, and this still happens.
I think most of us used cast/convert, and in those cases, it is 30.
- Aaron N. Cutshall wrote:
In times past, using varchar without a length defaulted to 30 characters. Did that change?
No. It hasn't changed. What it says in BOL has been true since I can remember and I also checked copies of BOL back to 2016.
When n isn't specified in a data definition or variable declaration statement, the default length is 1. If n isn't specified when using the CAST and CONVERT functions, the default length is 30.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Yep, that's what I was thinking about. Thanks for clarifying! 🙂
I've had my head embedded in Postgres for the last few years. It's not surprising something got pushed out in the process!
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com - Aaron N. Cutshall wrote:
Yep, that's what I was thinking about. Thanks for clarifying! 🙂
I've had my head embedded in Postgres for the last few years. It's not surprising something got pushed out in the process!
Heh... true dat.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply