Is NVARCHAR in SQL Server the same or similar to VARCHAR2 in Oracle? I might be wrong but doesn't SQL Server also support VARCHAR2? If so, what benefits (or problems) come from using NVARCHAR?

There is a holy war brewing between one of the development teams I'm involved with and the DBA group over using nvarchar vs varchar on a new SQL Server database. It's extremely unlikely that the ...