Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Chinese_PRC_CI_AS” in the equal to operation.

Check YourFieldName NVARCHAR(20) in Create Table

Replace this line to

YourFieldName NVARCHAR(20) COLLATE Database_default

From

YourFieldName NVARCHAR(20)