Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Wht is Stuff in sql ser

Question Posted / srinukatkam

Answers were Sorted based on User's Feedback



Wht is Stuff in sql ser..

Answer / lipsa

Stuff is a Sql server function.It Deletes a specified
length of characters and inserts another set of characters
at a specified starting point.



SELECT STUFF('abcdef', 2, 3, 'ijklmn')
::will return te following result::

aijklmnef

Is This Answer Correct ?    5 Yes 1 No

Wht is Stuff in sql ser..

Answer / sanjeev kumar

It is a inbuilt function that delete the character starting
from second parameter and No of character as in 3rd
parameter and place the all character of 4th parameter in
place of them.


Example:-

SELECT STUFF('sanjeev', 2,3, 'kumar')

Results:-

skumareev

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the differences between local and global temporary tables?

0 Answers  

Explain about system database?

0 Answers  

Can you please explain the difference between function and stored procedure?

0 Answers  

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

Explain what is log shipping?

0 Answers  

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

Is mysql the same as sql server?

0 Answers  

What are the two types of concurrency?

4 Answers  

What is user-defined scalar function?

0 Answers  

What are the purpose of Normalisation?

0 Answers   HCL,

Does sql server use t sql?

0 Answers  

Can a function call a stored procedure in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories