jQuery Show Loading Image While Page Loads or Show Loading Image in Webpage while Page Loads

Introduction: 

Here I will explain how to use jQuery to show loading image while page loading in jQuery or show loading image in webpage while page loading instead of blank page in jQuery.

Description:
  
In previous articles I explained jQuery query string parameter values with spaces, jQuery hide div elements after 5 seconds, jQuery check given date greater than current date jQuery Remove first/last character from string, Scroll back to top plugin Examples, jQuery create rounded corners for textbox and many articles relating to JQuery. Now I will explain how to show loading image while page loading in jQuery.

SQL Server - Show Time Difference in Minute Ago, Hour Ago, Day Ago, Week Ago, Month Ago

Introduction

Here I will explain SQL Server query to get date time difference in minute ago, hour ago, day ago, week ago or month ago format in SQL Server 2008 / 2005 or how to get date time format in minute ago, hour ago, day ago, week ago or month ago in SQL Server 2008 / 2005.

Description

In previous articles I explained SQL Server Get only date or time from date time field,  SQL Server get list of procedures which contains table name, SQL Server can function return multiple values, SQL Server update multiple tables with inner joins, SQL Server difference between view and stored procedure and many articles relating to SQL Server. Now I will explain how to write query to get date time in minute ago, hour ago, day ago, week ago or month ago format in SQL Server.

SQL Server - Get Date or Time From Date Time Column / Field in SQL Server 2008 / 2005

Introduction

Here I will explain SQL Server query to get only date or time from date time field in SQL Server2008 or 2005 or how to get only date or time from current date time field in SQL Server 2008 / 2005.

Description

In previous articles I explained sql server get list of procedures which contains table name, SQL Server difference between view and stored procedure, SQL Server difference b/w LEN and DATALENGTH functions and many articles relating to SQL Server. Now I will explain how to get only date or time from date time field in SQL Server.

SQL Server - Get Time Part Only From DateTime Column in 2008 / 2005

Introduction:

Here I will explain how to get only time from datetime in SQL Server 2008 / 2005 or SQL Query to get only time part from datetime column or field in SQL Server 2008 or 2005.

Description:

In previous posts I explained get only date from datetime in SQL Server, Add row items as string with comma separated values, Exception handling in SQL Server with try catch, Add identity property to existing column in sql server, update multiple tables using inner join in SQL Server many articles relating to SQL Server, asp.net, IIS, etc. Now I will explain how to get only time from datetime in SQL Server.  

SQL Server Get List of Stored Procedures Where a Table Name is Used

Introduction:

Here I will explain SQL Server query to get a list of stored procedures where table is used or SQL query to get list of procedures which contains table name in SQL Server.

Description:

In previous posts I explained can function return multiple values in SQL Server, Difference between view & stored procedure in SQL, update multiple tables using inner join in SQL Server many articles relating to SQL Server, asp.net, IIS, etc. Now I will explain how to get list procedures which contains particular table in SQL Server.  

SQL Server - Invalid Use of a Side-Effecting Operator 'insert' within a Function

Introduction:

Here I will explain how to solve the problem of “invalid use of a side-effecting operator 'insert' within a function in SQL Server”.

Description:

In previous posts I explained many articles relating to solve errors in asp.net, SQL Server, IIS, etc. Now I will explain how to solve the problem of “invalid use of a side-effecting operator 'insert' within a function in SQL Server”.

jQuery Autocomplete Clear Textbox After Select

Introduction:

Here I will explain how to clear autocomplete textbox in jQuery after select or jQuery clear autocomplete textbox after select.    

Description:

In previous posts I explained jQuery get selected text value from autocomplete, jQuery autocomplete textbox with webservice, jQuery autocomplete textbox with multiple words separated by commas, jQuery UI autocomplete textbox with database and many articles relating to autocomplete, asp.net, jQuery,  Now I will explain how to clear autocomplete textbox in jQuery after select.

SQL Server - Can Function Return Multiple Values in SQL Server 2008

Introduction:

Here I will explain how SQL Server function will return multiple values in SQL Server 2008 or return multiple values from SQL user defined function in SQL Server 2008.    

Description:

In previous posts I explained SQL Server difference between view and stored procedure, SQL Server split function example to split comma separated string, SQL Server update statement with inner joins, interview questions in asp.net, sql server, c# and many articles relating to SQL Server. Now I will explain how SQL Server function will return multiple values in SQL Server 2008.

jQuery Wiki Plugin to Show Wikipedia Description in Tooltips

Introduction:

Here I will explain how to use jQuery wikiup plugin to show or display wikipedia description in tooltips or show Wikipedia information related to word or string using jQuery wikiup plugin.

Description:
  
In previous articles I explained create simple tooltip with jQuery UI, show gridiview row details in tooltip on mouseover, jQuery Simple Slideshow example, jQuery image slideshow with text overlay, jQuery image slideshow with next and previous buttons and many articles relating to JavaScript, jQuery, asp.net. Now I will explain how to show Wikipedia information related to word or string using jQuery wikiup plugin.

SQL Server- Difference between View and Stored Procedure

Introduction:

Here I will explain difference between SQL SERVER view and stored procedure in SQL Server 2008.  

Description:

In previous posts I explained difference between wcf and web application, interview questions in asp.net, sql server, c#, Difference between functions and stored procedures in SQL Server, difference between len and datalength in sql server and many articles relating to SQL Server. Now I will explain the differences between SQL view and stored procedures.