Why is 30 the default length for VARCHAR when using CAST?

by

Why don’t you specify the varchar length? ie:

SELECT CAST('the quick brown fox jumped over the lazy dog' AS VARCHAR(45))

As far as why 30, that’s the default length in SQL Server for that type.

From char and varchar (Transact-SQL):

When n is not specified in a data definition or variable declaration statement, the default length is 1. When n is not specified when using the CAST and CONVERT functions, the default length is 30.

More Related Contents:

  1. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  2. Need to find list of tables used in stored procedure with “nolock”? [duplicate]
  3. Find and Replace Column value from Over all Database
  4. SQL query for display one field only once which having multiple record
  5. how to create this table in sql server?
  6. Exclude a column using SELECT * [except columnA] FROM tableA?
  7. Multi-statement Table Valued Function vs Inline Table Valued Function
  8. SQL Server Insert if not exists
  9. Dynamically create columns sql
  10. How to capitalize the first letter of each word in a string in SQL Server
  11. How to run a stored procedure in sql server every hour?
  12. SQL: Select dynamic column name based on variable
  13. How do I see active SQL Server connections?
  14. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  15. Why do you create a View in a database?
  16. The SQL OVER() clause – when and why is it useful?
  17. How to run a stored procedure every day in SQL Server Express Edition?
  18. How to copy a huge table data into another table in SQL Server
  19. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  20. Calculate the number of records for each date between 2 dates
  21. T-SQL: How to use parameters in dynamic SQL?
  22. How to compare datetime with only date in SQL Server
  23. Merge overlapping date intervals
  24. SQL server select distinct rows using most recent value only
  25. Split words with a capital letter in sql
  26. SQL poor stored procedure execution plan performance – parameter sniffing
  27. Generate random int value from 3 to 6
  28. RODBC Temporary Table Issue when connecting to MS SQL Server
  29. scope_identity vs ident_current
  30. Executing SQL query on multiple databases

Leave a Comment