It is considered a best practice to always be explicit about the length, as in CHAR(1) or VARCHAR(30).
- 2. Getting Started with the SELECT Statement
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Even though T-SQL can permit omitting it.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/8596/