1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the difference between varchar and varchar(max) datatypes?

Question Posted / shtakshi bhatnagar


What is the difference between varchar and varchar(max) datatypes?..

Answer / Shashank Mohan Shukla

'varchar' is a fixed-length string data type that stores up to 8000 characters. 'varchar(max)' is a variable-length string data type that can store up to 2^31 - 1 characters.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Can we use having clause without group by?

1 Answers  

What is oltp (online transaction processing)?

1 Answers  

How to return the date part only from a sql server datetime datatype?

1 Answers  

how to find the second salary?

10 Answers   HCL, Prithvi,

what is difference between NULL and ISNULL in SQL Server 2008?

1 Answers   MCN Solutions,

What is "scheduled jobs" or "scheduled tasks"?

1 Answers  

Explain syntax for viewing trigger?

1 Answers  

What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

Differentiate between delete and truncate.

1 Answers  

How many types of schemas are there?

1 Answers  

When would you prefer to have a minimum number of indexes?

1 Answers  

What happens when unicode strings concatenate with non-unicode strings?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories