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...