Converting an NVARCHAR to VARCHAR for fun and profit

NVARCHARdownsample.sql

/*	Preface the string with N or 
	SQL will pre-emptively destroy 
	the data before storing the string */
DECLARE @nv AS NVARCHAR(10) = N'╥«┘{║‼℈≠'
	, @v AS VARCHAR(10); 

SELECT @nv, CAST(@nv AS VARCHAR(10));
				
/*	And by reassigning we can see
	the data is permanently lost */
SELECT @v = @nv;

SELECT @v, CAST(@v AS NVARCHAR(10));