Have a Question?

If you have any question you can ask below or enter what you are looking for!



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

Hi,

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.

https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql


  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.


Thanks,

  Devbrat Tripathi       21 Apr 2017       0       0     

Post Your Answers:

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