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

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 Answers  

What is the purpose of sql profiler in sql server?

0 Answers  

How to drop existing indexes in ms sql server?

0 Answers  

why would you call update statistics? : Sql server database administration

0 Answers  

What is precedence constraint?

0 Answers  

What is the difference between OLEDB and ODBC

4 Answers   CFCI,

What is a trigger?

4 Answers  

What is meant by indexing?

0 Answers  

How do I edit a procedure in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories