Saturday, 21 January 2017

STUFF() - SQL Server

Description:
STUFF function is used to append number of characters from one string and replace them with another string. So, you can say this function insert string into another string, it removes all the specified length of string and insert other string value on that place.

Syntax
STUFF(stringstartlengthadd_string) 

Example:
1- SELECT STUFF('dotnetguru.in',12,2, 'com') as [stuff eg]

2- SELECT STUFF('www.dotnetguru.in',1, 0, 'http://')  as [stuff eg]

Output:

1- dotnetguru.com
2- http://www.dotnetguru.in

0 comments:

Post a Comment

Topics

ADO .Net (2) Ajax (1) Angular Js (17) Angular2 (24) ASP .Net (14) Azure (1) Breeze.js (1) C# (49) CloudComputing (1) CMS (1) CSS (2) Design_Pattern (3) DI (3) Dotnet (21) Entity Framework (3) ExpressJS (4) Html (3) IIS (1) Javascript (6) Jquery (9) Lamda (3) Linq (11) Mongodb (1) MVC (48) NodeJS (7) RDLC (1) Report (1) Sql Server (29) SSIS (3) SSRS (2) UI (1) WCF (12) Web Api (9) Web Service (1) XMl (1)