ASP.NET Web Forms
ASP.NET Web Forms is a part of the ASP.NET web application framework and is one of the three different programming models you can use to create ASP.NET web applications, the …
jQuery PageX/Y Event
The jQuery event pageX and pageY provides the position of the mouse pointer, relative to the left edge pageX and/or right edge pageY of the document. Syntax Basic Example In …
Displaying a GIF During IFRAME Loading Using jQuery
If you are including iframe elements in your HTML pages, you may want to consider displaying a simple “loading” indicator to let your end users know that content is being …
jQuery Sliding Effects
jQuery has several methods that can be used to create a variety of sliding animation effects. The use of jQuery among web designers continues to be growing in popularity. With …
SQL CREATE TABLE Statement
The SQL CREATE TABLE statement can be used to create a table within a SQL database. Syntax Example Results employeeID employeeName hireDate The CREATE TABLE statement used …
Leveraging Temporary and Variable Tables in SQL
When manipulating data especially from SQL views that require several minutes to produce results that are executed several times while running jobs, you may find the use of temporary or …
SQL DATEDIFF Function
The DATEDIFF function is used in Microsoft SQL Server to return the time between two dates/date columns. Employees Table employeeID employeeName hireDate 1000 John Smith 1995-12-03 1001 Fred White 2001-10-12 …
MySQL CURDATE Function
The MySQL CURDATE function is used to display the current date. The equivalent function in Microsoft SQL Server is GETDATE, but would require formatting with the CONVERT function. Syntax Example …
SQL Order By Keyword
The ORDER BY keyword is used to sort the result-set by one or more specified fields (columns). The ORDER BY keyword sorts the records in ascending order by default. If …
Stored Procedure Parameters
One or more parameters can be declared in a CREATE PROCEDURE statement. The value of each declared parameter must be supplied by the user when the procedure is executed unless …
SQL INNER Join
The SQL INNER JOIN keyword returns rows when there is at least one match in both tables. Relational databases are often normalized to eliminate duplication of information when objects may …
jQuery $(Document).Ready
When working with jQuery, it is a good idea to wait for the document to be fully loaded, prior to executing jQuery code on the page. One of the first …