Senator Guerra Souty original series calendar,replica hublot blue steel peach pointer collocation of rolex replica Rome digital scale, track type minute replica watches scale shows that the classical model is swiss replica watches incomparable, wearing elegant dress highlights.
mr-ponna.com

 

YOU ARE HERE: HOME Questions What is difference between STUFF and REPLACE in SQL Server

About STUFF and REPLACE in SQL Server

 View(s): 42877

What is difference between STUFF and REPLACE in SQL Server

Answer 1)

REPLACE is used to replace all the repition.
STUFF function is used to overwrite existing characters.

Using this syntax, STUFF (string_expression, start, length, replacement_characters)

for Ex: SELECT STUFF('SQL SERVER is USEFUL',5,6,'DATABASE')

Here SERVER is replaced with DATABASE
5 is position of S(ERVER)
6 is length of (1S 2E 3R 4V 5E 6R)

OUT PUT : SQL DATABASE is USEFUL
  Asked in:  TCS (Tata Consultancy Services)   Expertise Level:  Experienced
  Last updated on Tuesday, 29 October 2013
4/5 stars (35 vote(s))

Register Login Ask Us Write to Us Help