Collections:
CHAR(n) - Truncating/Padding Strings in SQL Server Transact-SQL
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL?
✍: FYIcenter.com
When the length of the input string does not match the storage size of the fixed length string data type CHAR(n). SQL Server will:
The tutorial exercise shows you good examples of truncating and padding fixed length character strings:
-- Length matches the data type size DECLARE @msg CHAR(36); SET @msg = 'Welcome to FYIcenter.com SQL Server!'; PRINT '('+@msg+')'; ---------------------------- (Welcome to FYIcenter.com SQL Server!) -- Length is bigger than the data type size - truncated DECLARE @msg CHAR(24); SET @msg = 'Welcome to FYIcenter.com SQL Server!'; PRINT '('+@msg+')'; ---------------------------- (Welcome to FYIcenter.com) -- Length is smaller than the data type size - padded DECLARE @msg CHAR(46); SET @msg = 'Welcome to FYIcenter.com SQL Server!'; PRINT '('+@msg+')'; ---------------------------- (Welcome to FYIcenter.com SQL Server! )
2017-05-13, 2055👍, 0💬
Popular Posts:
How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...