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

 



© 2018 | Анна Петросян | pashelp@yandex.ru