Posted on Leave a comment

Possible ways to connect SharePoint Office 365 to External databases – SharePoint Stack Exchange

In order to connect the external database to SharePoint online, you can consider deploying the Business Connectivity Services (BCS). First of all, the subscription eligible for the BCS requires an Office 365 Enterprise E3 or E4 subscription. If your Office 365 subscription meets the requirement, please be aware that Business Connectivity Services in a SharePoint Online tenancy can only access data from WCF Data Services and SQL Server Azure Connectors. http://technet.microsoft.com/en-us/library/ee661740(v

Source: Possible ways to connect SharePoint Office 365 to External databases – SharePoint Stack Exchange

Posted on Leave a comment

Update linked server table based on local table – Database Administrators Stack Exchange

1 down vote accepted You cant have 5 identifiers, this should do the trick UPDATE T2 SET T2.cod = T1.codigo FROM [HQSQLHOM01\SQLHOM01].dba_teste.dbo.tabela2 AS T2 JOIN tabela1 AS T1 ON T1.id = T2.id https://technet.microsoft.com/en-us/library/ms190406(v=sql.105).aspx shareimprove this answer

Source: Update linked server table based on local table – Database Administrators Stack Exchange