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 ...
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 ...
In our previous article, we have described the functionalities of CHARINDEX (link) and we have briefly described the use of SQL Server SUBSTRING function too. A SUBSTRING function will extract a part ...
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 ...
SQL Server “DATE” and “DATETIME” data types store date and time values in a table. However, managing these values can sometimes be little difficult, especially if the value saved is “1900-01-01”. And ...
Dummy database tables can be very useful in many ways, such as testing an application for data manipulation, data integrity. In addition, you can test other data driven tools such as a GridView ...
So, you have migrated from an old operating system to a new one and also left behind your previous version of SQL server to migrate to a new version of SQL server database. In addition, while ...
Sql Server built-in functions provide many useful functions to perform various operations on data. The data can range from “String”, “Texts” or “Numeric”. This article highlights the use of “LEFT ()” ...
Sql Server Indexes (which are typically referred to as database objects) help in quickly retrieving data from a “Table” thereby giving a tremendous boost in improving the performance of Sql queries. ...
It can be annoying when you have installed a brand new software on your PC, and it refuses to function the way you expect it to. ...
