We use JOIN in the SELECT statement often to retrieve data from multiple related tables. But, some times we can get into a situation where we may need to use UPDATEstatement by joining multiple tables. Consider a situation: A table named as USER_DATA is there which contains user details. This table has one column(along with other columns) named as  IS_ACTIVE […]

At times you may need to UPDATE a row from a Table and at the same time you would also want to get the column value from the same SQL UPDATE query. Following is a solution using SQL OUTPUT clause . SQL OUTPUT clause :     The OUTPUT Clause from SQL server provides a very […]

What is -dry-run? The -dry-run is a method that is used to figure out what are the files that would get actaully updated when you update your svn repository. When and how it is useful? case 1: This is mainly used when you are working in a big team, and before you commit the day’s […]

What is the general approach we follow when we try to add / edit a SPListItem using the SharePoint object model? Yes I know it! Almost everybody will have a common answer to this (which is something similar to what is provided below). SPListItem item = SPList.Items.Add(); item[“Column1”] = “value for column 1”; item[“Column2”] = […]