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 steps you can take to avoid “deadlocks”?

0 Answers  

What is sparse columns of sql server 2008?

0 Answers  

how to invoke a trigger on demand? : Sql server database administration

0 Answers  

What is auditing in sql server?

0 Answers  

What is transcation?Plz give One example?

2 Answers  

What is the difference RDBMS and Graph Database?

0 Answers   EXL,

How can you get @@error and @@rowcount at the same time?

9 Answers  

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

Can we delete data from a view?

0 Answers  

How can windows applications connect to sql servers via odbc?

0 Answers  

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

What is analysis service repository?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories