Wht is Stuff in sql ser
Answers were Sorted based on User's Feedback
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 |
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 |
what is the diffrence between Snap Shot and Transaction Replication
what is unique and xaml nonclustered index
There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.
How to tune a stored procedure?
Difference between Triggers and Stored Procedure
23 Answers Claimat, HCL, Protech, Silgate,
What is ms sql server service broker?
what is a cursor and what is its use?
Where are full-text indexes stored?
What is clustered primary key?
Wht is Stuff in sql ser
what is denormalization and when would you go for it? : Sql server database administration
Explain DBCC?