SQL NVARCHAR(Max) Data Type

A table with 2 VARCHAR(Max) columns.

CREATE TABLE DemoTable  
( 
  Id INT IDENTITY, 
  FullName NVARCHAR(100),
  Subject NVARCHAR(Max),
  Message NVARCHAR(Max)
);
GO  

INSERT INTO DemoTable VALUES ('Harold Smith', 'Technical Support', 'Hi, please help me fix ...');  
INSERT INTO DemoTable VALUES ('Robert Wang', 'After Sales', 'Greetings! I need to know the details ...');  
INSERT INTO DemoTable VALUES ('Janice Lopez', 'After Sales', 'Are you also opening ...');
INSERT INTO DemoTable VALUES ('Kelly Wilson', 'Customer Support', 'Can you help me find the ...'); 
INSERT INTO DemoTable VALUES ('Grace Taylor', 'Technical Support', NULL); 
GO  

SELECT * FROM DemoTable;
GO

DROP TABLE DemoTable;
GO

Very large character strings can be stored in Subject and Message.

Syntax of NVARCHAR(Max).

NVARCHAR(Max)

SELECT MONTH(OrderDate) AS [Month],
       '$' + CONVERT(NVARCHAR(max), SUM(CAST(TotalAmount AS MONEY)), 3) 
             AS 'Total Sales'
  FROM [Order]
 WHERE YEAR(OrderDate) = 2013
 GROUP BY MONTH(OrderDate)
 ORDER BY MONTH(OrderDate)

Storing values in NVARCHAR(Max) is overkill in this situation. A smaller VARCHAR or CHAR type would suffice.

Month	Total Sales
1	$ 66,692.80
2	$ 41,207.20
3	$ 39,979.90
4	$ 55,699.39
5	$ 56,823.70

• Our Sql NVARCHAR Data Type Reference
• Our Sql VARCHAR Data Type Reference
• Our Sql Data Types Reference