" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

How to use UPDATE with JOIN in SQL queries

Posted on November 24th, 2015 by Mritunjay Kumar

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 […]

INSERT, UPADTE or DELETE a row and return column/columns value with single query

Posted on November 24th, 2015 by Santosh Bisoyi

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 […]

Use of -dry-run in svn

Posted on November 23rd, 2015 by Satheeskumar A

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 […]

Update vs. SystemUpdate for SharePoint List Item

Posted on November 23rd, 2015 by Kaushik Mohanty

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”] = […]