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 …
Tag: TSQL
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 …