User Id :    Password :      New Member   Forgot Password  
Topic: What is stuff function in SQL SERVER
Shaheen
29 Jul 2011 at 11:31 PM
Stuff function in SQL server replaces a specified length of characters with a new set of characters from a string at a given starting location. 

Syntax: STUFF ( original_string , startposition , string_length_to_be_replaced ,replacing_string )

For more detail please check this url 

http://www.dotnetlogix.com/article/sqlserver/131/Introduction-to-stuff-in-SQL-Server.html


Re: What is stuff function in SQL SERVER
Dc Attri
09 Aug 2011 at 10:48 PM

STUFF function is used to overwrite the existing charecters.

Syntax for this is  : STUFF(String_exp, Start, Length, Replacement Charecters)

 String_exp: String in which you want to replace Charecters

Start: Starting Position from where you want to start replacement

Length: No of charecters you want to Replace

Replacement Charecter: New Charecters with which you want to replace old charecter

Total Replies: 1
 
Featured Text Ad

Featured Ad