SQL – Some useful commands and features

SET NOCOUNT –  Stops the message that shows the count of the number of rows affected by a Transact-SQL statement or stored procedure from being returned as part of the result set. SCOPE_IDENTITY( ) – Returns the last identity value inserted into an identity column in the same scope. A scope is a module: a…


Order of Page Events for ASPX Page, Master Page and User Control in ASP.NET

When an .aspx page is loaded in ASP.NET, the different page events are called in the following order for the .aspx page, master page and any user control on that page.   “OnLoad”   and   “PreRender” ASPX Page Master Page User Control   “Init”   and   “UnLoad” User Control Master Page ASPX Page


How to rotate the items in Announcement List in SharePoint

In SharePoint, Announcements list is used to display news items and other short bits of information related to important activities or events. So, instead of sending mails to site members to share such information, one can post the same by adding an Announcements list app to the site. An Announcements list contains the following columns :- Title, Body, Expires, Created…