• nvarchar has a max length of 4000 not 8000

    the 'N' in this statment converts it;

    set @C = N'hello'