https://sqlines.com/ 2026-04-13T18:34:09+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2012-07-26T09:42:59+00:00 https://sqlines.com/sql-server/datatypes/nchar?rev=1343295779&do=diff In SQL Server, NCHAR data type stores fixed-length string data in Unicode UCS-2 character set. SQL Server: CREATE TABLE states ( id NCHAR(2), name NCHAR(20) ); -- Data can be inserted using Unicode and regular constant INSERT INTO states VALUES (N'CA', 'California'); text/html 2012-07-25T15:47:11+00:00 https://sqlines.com/sql-server/datatypes/timestamp_rowversion?rev=1343231231&do=diff In SQL Server, ROWVERSION and TIMESTAMP data types represent automatically generated binary numbers, unique within the database. ROWVERSION and TIMESTAMP are synonyms, ROWVERSION is available since SQL Server 2005, while TIMESTAMP is deprecated and will be removed in a future version of SQL Server .