SQL Query to Get Latest Unique Records by Date

Introduction:

Here I will explain how to write query to get latest or recent records but unique records in SQL Server.

Description:

In previous articles I explained joins in SQL Server, Get Records without weekends, SQL Query Get Month Wise Data, difference between function and stored procedures, and many articles relating to SQL Server. Now I will explain how to write a query to get latest or recent records but unique records in SQL Server.

SQL Query to Get Month wise Data, Year wise Data

Introduction

In this SQL Server article I will explain how to write query to get monthly (month wise) data or year wise data from database.

Description

In previous articles I explained Query to get Exclude weekends in SQL Query, While Loop Example in SQL Server, Find First and last day of current month in SQL, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server.  Now I will explain how to write query to get month wise data or year wise data from database in SQL Server.

How to Exclude Weekends in SQL Query or Get Records Without Weekends

Introduction:

In this SQL Server article I will explain how to write query to get records Exclude weekends data or without weekends data in SQL Server.

Description:

In previous articles I explained insert single quote data in database, DateAdd function Example, Pass table as parameter to procedure, difference between function and stored procedures, joins in SQL Server and many articles relating to SQL Server. Now I will explain how to write a query to get records without weekend’s data in SQL Server.

SQL Server Insert Data with Apostrophe/Single Quote in Database

Introduction

In this SQL Server article I will explain how to insert single quote or apostrophe data in database.

Description

In previous articles I explained While Loop Example in SQL Server, Find First and last day of current month in SQL, Convert Rows to Columns in SQL, Joins in SQL Server and many articles relating to SQL Server.  Now I will explain how to insert single quote or apostrophe data in SQL Server.

jQuery: Convert Text to UpperCase or LowerCase

Introduction: 

In this jQuery article I will explain how to change text to uppercase or lowercase or convert text to uppercase/lowercase using jQuery in asp.net.

Description:
  
In previous articles I explained Change the style of tooltip in jQuery, jQuery Countdown timer script example, jQuery Increase or Decrease font size of website, Redirect to another page after some time delay, jQuery slideUp slideDown toggle effects and many articles relating to JQuery and asp.net. Now I will explain how to convert text to uppercase or lowercase using jQuery in asp.net.

jQuery UI Datepicker: Disable Specific Days

Introduction: 
  
In this jQuery UI Datepicker article I will explain how to disable specific days in jQuery datepicker.

Description:
  
In previous posts I explained Disable specific dates in Calendar, Disable Future dates in Calendar, Disable weekends in datepicker, Show multiple months in datepicker and many articles relating to JQuery and datepicker. Now I will explain how to disable specific days in jQuery datepicker.

jQuery ui Datepicker Disable Dates before Today

Introduction: 
  
In this jQuery UI Datepicker article I will explain how to disable dates before today or previous dates in jQuery datepicker.

Description:
  
In previous posts I explained Disable specific days in Calendar, Disable Future dates in Calendar, Disable weekends in datepicker, Show multiple months in datepicker and many articles relating to JQuery and datepicker. Now I will explain how to disable dates before today in jQuery datepicker.

Disable Specific Dates in jQuery UI Datepicker

Introduction: 
  
In this jQuery UI DatePicker article I will explain how to disable specific days or dates in jQuery datepicker.

Description:
  
In previous posts I explained Disable Future dates in Calendar, Disable past dates, Disable weekends in datepicker, Show multiple months in datepicker and many articles relating to JQuery and datepicker. Now I will explain how to disable specific dates in jQuery datepicker.

jQuery How to Get Mouse Cursor Position

Introduction: 

In this jQuery snippet I will explain how to get current mouse or cursor position in jQuery.

Description:
  
In previous posts I explained jQuery Allow only numbers in textbox, jQuery Accordion Menu Example, jQuery lightbox slideshow, jQuery Create Rounded Corners Textbox and many articles relating to JQuery, Asp.net. Now I will explain how to get current position of mouse or cursor in JQuery.

JavaScript Restrict User to Enter Numeric Value in Textbox

Introduction: 

Here I will explain how to restrict user to enter numeric value in textbox using JavaScript in asp.net.

Description:
  
In previous posts I explained JavaScript Redirect to another page after 5 secs, Watermark for textbox in JavaScript, jQuery lightbox slideshow, Password strength jquery plugin examples and many articles relating to JavaScript, JQuery, Asp.net. Now I will explain how to restrict user to enter numeric value in textbox using JavaScript in asp.net.