Character Strings : text « Data Types « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Data Types
3. text

9> Create table Contacts(ContactId char(8),
10>      Name varchar(50),
11>      Note text,
12>      Resume varchar(max))
13> GO
1>
2> insert into Contacts (ContactId, Name, Note, Resume)
3>      values ('CO-92-81', 'Tom Jones', 'Tom@trigon.com', 'N/a')
4> GO

(1 rows affected)
1>
2> drop table Contacts;
3> GO
1>