sql - Where do I put the collation clause? -

sql - Where do I put the collation clause? -

please see query below:

select idnumber collate sql_latin1_general_cp1_ci_as ciscrimeurn, wid nicheoccurrenceid, occurrencefileno nicheoccurrencefilno [rmslive\sql2005].nicherms_live.dbo.tbl_goccid inner bring together [rmslive\sql2005].nicherms_live.dbo.tbl_goccurrence on tbl_goccid.wid = tbl_goccurrence.id tbl_goccid.id '2060609955%' union select null ciscrimeurn, id nicheoccurrenceid, occurrencefileno nicheoccurrencefilno [rmslive\sql2005].nicherms_live.dbo.tbl_goccurrence id not '90309955%' except select cisidnumber collate sql_latin1_general_cp1_ci_as, occurrenceid, occurrencefileno dbnichecis

nicherms_live , dbnichecis have different collations. both sql server databases.

ciscrimeurn varchar, nicheoccurrenceid decimal , occurrencefileno integer. not understand set collation clause.

if want alter column collation then

select columnname collate collation_name tablename

sql sql-server