Have you ever been in a situation where you needed to write a query that needed to do comparisons or access data from the subsequent rows along with the data from the current row? This article discusses different ways to write these types of queries and more specifically examines LEAD and LAG analytics functions, which were introduced with SQL Server 2012, and helps you understand how leveraging these functions can aid you in such situations.

FIGCAPTION Element is used to put an additional information about the image. As if we have to give a discription about the image, we don't need to embed an another paragraph to define the description. It may slightly complex also, to use another paragraph and style it with the displayed image. So with FIGCAPTION Element, we can define a description and it will automatically adjust its surrounding style according the image.

11 Responsive Web Editing Tools for Designers!

I started the journey for this blog because I wanted to make sure I understood all the differences between TRUNCATE and DELETE. What I discovered is that the main difference is that TRUNCATE is DDL and DELETE is DML. As if there aren’t enough acronyms to remember, here you go.

The jQuery get() and post() methods are used to request data from the server with an HTTP GET or POST request.

What is the Value of the MERGE Statement? Prior to the introduction of SQL Server 2008 if you needed to write logic that inserted rows into a target table if they didn’t exist, or updated them if they did exist you needed a series of “if then else” logic and needed to perform both the UPDATE and INSERT statement. With the introduction of the MERGE statement with SQL Server 2008 you can perform either an INSERT or UPDATE statement using a single MERGE statement. Being able to use the MERGE statement to perform inserts or updates to a table makes it easier to code your UPSERT logic in TSQL.

Take a reference of latest jQuery in your source. I am using jquery-1.10.2.js in my example. In the form tag of your Web form add your controls which you would like to use in the page. Simply Copy and Paste the below code in the script tag :

OverAPI.com is a site collecting all the cheatsheets,all!

The Google Calendar API allows you to create and modify events on Google Calendar. Starting today, you can use the API to also attach Google Drive files to Calendar events to make them—and your app—even more useful and integrated. With the API, you can easily attach meeting notes or add PDFs of booking confirmations to events.

Ajax (Asynchronous JavaScript and XML) is a technique to exchange the data with the server, updating part of a web page without reloading the page again. Using Ajax we can fetch data from various sources like XML, Json, Jsonp or MySQL Database. In this article you can learn how to implement ajax feature on your webpage and fetch data from various sources like XML, Json and Mysql database and display the data. I will be using jQuery ajax() function to do this task.