how to insert unicode text to SQL Server from query window

The following should work, N indicates a “Unicode constant string” in MSSQL:

INSERT INTO tForeignLanguage ([Name]) VALUES (N'Араб')