We have two different databases on the same server. The server collation is Latin1_General_CI_AS.
Database A is the same as the server collation.
Database B is a vendor product database using SQL_Latin1_General_CP1_CI_AS.
I will have some joins and compares of data on the two different database and then to load data from Database B into Database A daily.
When should I use the collate statement?
The two database are only English, no other language or characters. Datatype are all like int, char, varchar, date etc. no uni code.