How to call different language by using "select" in MS-SQL 2005

Hello,
i'm going to develop bulletin board that can be compatiable with different language.
In Web, i need to call  Table & SP  content which includes korean language.
The best way is set to whole database default language as korean. but godaddy does not alllowed me to change the MS-SQL default language (since they are hosting with others)

but, i found some way that, whenever I inserted  data, i should use like
 INSERT INTO [table] VALUES (N'content')

also, when i call the data then i can use like below
SELECT [column_name_1] COllECTION Korean_Wansung_CI_AS FROM [table]

but, my question is how can i use MUTIPLE columns (or left join, inner join, etc ) in "select"

also, how to use Korean_Wansung_CI_AS by using " Update " command

Thanks in advance