What Is a Stored Procedure and Why Use it? - SQL Server

An SQL Server Stored Procedure is a logical collection of statements or queries packaged together to perform a particular task, repeatedly. You do not have to write the statements repeatedly and it saves not just time but also other server resources.

Continue reading...

Try… Catch – Exception Handling in SQL Server

Exception handling or Error handling in SQL Server is a process of handling errors during execution of a Stored Procedure or a Trigger. It has similarities with other programming language exception handling technique like C# or Vb.Net.

Continue reading...

SQL Server SUBSTRING Function with Examples

In our previous article, we have described the functionalities of CHARINDEX and we have briefly described the use of SQL Server SUBSTRING function too. A SUBSTRING function will extract a part of string from a string. This function will help you locate a single or multiple characters from a phrase or an entire sentence.

Continue reading...

SQL Server CHARINDEX Function with Examples

The primary use of an SQL Server CHARINDEX function is to find the first or starting location of an expression or characters in a given string. To make it simple, it is like searching a specified character or characters in a string.

Continue reading...

Restrict or Disable Browser Back Button Using JavaScript

This is one JavaScript trick out of many, which is not advisable to use in websites, though very useful in terms of security and integrity of online data. Restricting or Disabling the Browser back button can be very annoying for users who might wish to go back to the previous page from the existing page.

Continue reading...

Find the File Extension using JavaScript and JQuery

Dealing with files can be cumbersome since you will have to manage them using server side scripts. At least there are ways to find the type or extension of the files you are dealing with, using client side scripts like JavaScript and JQuery.

Continue reading...

Blink or Flash Multiple Cells in Excel using VBA’s OnTime method

Excel is a very useful application for managing data on a spreadsheet. Its VBAtools and functions have made it more dynamic and appealing. Macros can make the contents in the file more meaningful and organized.

Continue reading...

Get All The Child DIV IDs Inside a DIV Using JQuery

Sometimes we need find child element id’s inside another element. Traditionally, a “DIV” used as a container and there can be other DIV elements inside it. You can place these elements during the designing of the web page or create and insert in it dynamically.

Using JQuery ".map()" function, we can extract the child id's with out even running a single loop. 

Continue reading...

Clear all textbox values inside a container using JQuery

JQuery has definitely made the lives of programmers easy in many ways. One of the features we will discuss in this article is how to clear values in all textboxesinside a container with just a click of a button, using JQuery. The container can be either a “DIV” a “Panel” or a “Table”.

$('#btClearAll').click(function() {     });

Continue reading...

Multiple File Upload in Asp.Net

Microsoft’s .Net has a come a long way when it comes to uploading various types of files. With Asp.Net version 2.0, it has introduced the “FileUpload” server side control for the very first time. This has virtually simplified the file uploading process.

Continue reading...