Wht is Stuff in sql ser

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 is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,


what is unique and xaml nonclustered index

0 Answers  


There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,


How to tune a stored procedure?

6 Answers  


Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,






What is ms sql server service broker?

0 Answers  


what is a cursor and what is its use?

2 Answers   L&T,


Where are full-text indexes stored?

0 Answers  


What is clustered primary key?

0 Answers  


Wht is Stuff in sql ser

2 Answers  


what is denormalization and when would you go for it? : Sql server database administration

0 Answers  


Explain DBCC?

0 Answers   QuestPond,


Categories