T-SQL | SELECT FROM Linked Server & COLLATE

Пример запроса к связанному серверу (Linked Server), с приведением полей к русской кириллице (Cyrillic_General_CI_AS):

SELECT

CONVERT(float, ClientID) AS [ClientID]

,ClientName COLLATE Cyrillic_General_CI_AS AS [Client Name]

,CONVERT(varchar(200), ProductCatergoryNbr) COLLATE Cyrillic_General_CI_AS AS [Product Category]

FROM ServerName.DBName.OwnerName.TableName TableNameAlias