which datatype in SQL server can be used to store number and text values


I want to store number and text values in one of the column in SQL table, can you guide me which datatype should i use so that i can store number and text both.

  Devbrat Tripathi

is it Ntext ?

As per MS books this data type has now been deprecated.


  Arun Madhavan       19 Apr 2017       0       0     

Hi Arun,

I checked NText but it is not apropriate for storing number and text. You can use Nvarchar to store number and 

text data type.


  Devbrat Tripathi       21 Apr 2017       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any