SQL INBUILD Function

https://docs.microsoft.com/en-us/sql/t-sql/functions/stuff-transact-sql


STUFF (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse
The STUFF function inserts a string into another string. It deletes a specified length of characters in the first string at the start position and then inserts the second string into the first string at the start position.
Topic link icon Transact-SQL Syntax Conventions

Syntax

STUFF ( character_expression , start , length , replaceWith_expression )

Arguments

character_expression
Is an expression of character data. character_expression can be a constant, variable, or column of either character or binary data.
start
Is an integer value that specifies the location to start deletion and insertion. If start is negative or zero, a null string is returned. If start is longer than the first character_expression, a null string is returned. start can be of type bigint.
length
Is an integer that specifies the number of characters to delete. If length is negative, a null string is returned. If length is longer than the first character_expression, deletion occurs up to the last character in the last character_expression. If length is zero, insertion occurs before the first character in the string. length can be of type bigint.
replaceWith_expression
Is an expression of character data. character_expression can be a constant, variable, or column of either character or binary data. This expression replaces length characters of character_expression beginning at start. Providing NULL as the replaceWith_expression, removes characters without inserting anything.

Comments

Post a Comment

Popular posts from this blog

Filegroups - Creating a new file group and making it the default

Image
Ref-1 https://blog.sqlauthority.com/2009/05/31/sql-server-create-multiple-filegroup-for-single-database/ https://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/07/11/881.aspx https://www.sqlshack.com/database-table-partitioning-sql-server/ https://blog.sqlauthority.com/2013/08/15/sql-server-sql-basics-what-are-filegroups-day-9-of-10/ Filegroups - Creating a new file group and making it the default There are many occaisons where you may want to use multiple filegroups, especially if dealing with large tables and fragmentation is a worry. The script below shows a complete end-to-end example of how to create a file group and mark it as the default so all newly created objects are placed on there. Note, there is nothing you can do about [PRIMARY] so if you have creation scripts or drop / recreate index scripts with [PRIMARY] in them then that data will always go on the [PRIMARY] file group. -- Create the database CREATE DATABASE te...
Read more

Package Deployment in SSIS using example

Image
http://www.learnmsbitutorials.net/package-deployment-ssis.php Introduction Hello Friends, welcome to learn #MSBI step by step I'm your #MSBI host Gurunatha S.Dogi. Little About Me : I'm one of the trainer in Questpond having more than 8 yrs of experience in #server tools, #programming and #seo. I do take trainings for freshers or an individual with 3 yrs of experience. My focus area to teach / concentrate freshers to make them comfortable in learning technology step by step. In short to make their basics strong to get started into tech world. If you want to learn #MSBI step by step then feel free to touch base with the below mentioned details. Today, In this session we will learn how to do SSIS project deployment or SSIS package deployment step wise or to deploy SSIS project into production server. SSIS Project Deployment Step by Step Deployment : Deploying is nothing but moving something from one place to another place. For example let's say dep...
Read more