Development

SELECT from table WHERE items IN (@variable)

You need to make query like “SELECT * from tbl WHERE items IN (‘item1’, ‘item2’, ‘item3’, ‘item4’)” and you want to send items to IN clause as variable. It’s nice when, for example, you want to execute Stored procedure or, as in example below, use INSERT … SELECT construction. Then you need to make a […] Read more»

SQL and databases

Copy file to all SharePoint farm server using PowerShell

If you have a SharePoint Farm and you need to update only one file, for example, in LAYOUTS dir (c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\…), there’s no need to go to every server and copy file. Using PowerShell and some strings of code below you can easily do it. Read more»

SharePoint

How to change SQL server in SharePoint Farm

If you need to go through some steps of disaster recovery plan with your SharePoint 2010 Farm after falling down your MS SQL server (of course if it’s not on the same machine with your SharePoint), there are some steps to do it. I’ll describe steps how to install another instance of MS SQL Server […] Read more»

SharePoint

Get List info by ID in SharePoint

Using PowerShell it’s rather easy to find information list. In messages about denied access (especially in custom SharePoint solutions) you can see in URL ID of denided list. To find-out where it is you can using this script:  Read more»

SharePoint

Change table columns order via jQuery

When you have a table which you can’t edit, you think you can’t do anything with it. It may be a result of an outside procedure or web-service (usually it returns data in XML, but html-table also can be). So, for example, we have a list of Borussia Dortmund players. We know id in list, […] Read more»

React

Popular Posts