When writing a Microsoft SQL Server store procedure, it is normal to have multiple stored procedures for each CRUD operation (Create, Read, Update, Delete) – SELECT, INSERT, UPDATE and DELETE. However, is it possible to simplify this Transact-SQL logic into a single SQL Server stored Read More …
Category: TSQL
Dynamic Search Conditions in T‑SQL
Introduction It is very common in information systems to have functions where the users are able to search the data by selecting freely among many possible search fields. When you implement such a function with SQL Server there are two Read More …
SQL MERGE statement
With data processing, in performing ETL workloads to a data warehouse, some of the activities in ETL can be achieved using the MERGE statement in SQL. The MERGE statement in SQL is a special type of query in SQL Server Read More …
A Stored Procedure to generate a random token
You may have encountered a scenario where you want to generate a random token for identity verification purposes. In this article I tried to include a stored procedure in which you can easily generate a random token to be sent Read More …
SQL Server – Indexes
Why do we need indexing a table? Because without an index the SQL server has to scan the entire table to return the requested data. It is like the index page in a book. You check within the index for the Read More …
SQL Server: STUFF() Function
In SQL Server (Transact-SQL), the STUFF() function deletes a sequence of characters from a source string and then inserts another sequence of characters into the source string, starting at a specified position. Syntax The syntax for the STUFF function in Read More …
Delete Duplicates From a Table in SQL Server
You can use the following ways to delete duplicate rows from a table in SQL Server. Let’s create a sample Employee table and insert a few records in it. CREATE TABLE Employee([ID] INT identity(1,1),[FirstName] Varchar(100),[LastName] Varchar(100),[Country] Varchar(100),)GOInsert into Employee ([FirstName],[LastName],[Country] Read More …
SSISDBBackup.bak could not be accessed
If you try and create an Integration Services Catalog and you receive the error SSISDBBackup.bak could not be accessed, it could be because you do not have Integration Services installed on your SQL Server instance. Below I am going to Read More …