New answers tagged sql
Can you try following connection string: Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI; User ID=myDomain\myUsername;Password=myPassword; Source: ConnectionStrings.com
The issue is now resolved. In the update query shown above: WHERE AppFileSystemFin.ID = [ID]; This line does not refer to SharePoint's system-generated ID column. Instead, it refers to an internally generated key field that we had to use in order to be able to perform SQL join operations between lists. The query has been updated to use SharePoint's ...
It really depends on the situation. Sure, conventional wisdom says never query in SQL. Yet this is counter to all the logic in non-SharePoint solutions. It is especially relevant with large datasets. If you take care of business in SQL, you end up with less data to send across the wire. Of course that's fastest. It is especially relevant for none SharePoint ...
Top 50 recent answers are included