When you need to store character strings, if they will likely vary in length, use the NVARCHAR or VARCHAR data types rather than the fixed NCHAR or CHAR. If the column value might be updated often, and especially if it is short, using the fixed length can prevent excessive row movement.
- 8. Creating Tables and Enforcing Data Integrity
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
CHAR and NCHAR require data to be the same length.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/68314/