Variable-length character data type in Transact-SQL.
Variable-length character data type in Transact-SQL. More info: https://msdn.microsoft.com/en-us/library/ms186939.aspx.
Questions tagged [nvarchar]
483 questions
-3
votes
2 answers
SQL In an EAV model, does the length of the nvarchar matter?
I'm looking to set up a Entity-Attribute-Value table model, where I want the table to handle various data. I'd like to use nvarchar(max), but I'm worried that it may affect database performance (even though most data will be under 50 chars).
Daniel
- 34,125
- 17
- 102
- 150
-4
votes
1 answer
Fix invalid datatype error, nvarchar is invalid
I have the query:
Select
Location, date, total_cases, total_deaths,
(total_deaths / total_cases) * 100 as DeathPercentage
From
PortfolioProject.dbo.CovidDeaths$
Order By
1, 2
But when I run it I get this error:
Msg 8117,…
JC234
- 1