Answer Posted / 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 View All Answers
Explain user defined functions?
What are the different normalization forms?
Explain security with sql azure?
List the different types of collation sensitivities in sql server?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
How to use transact-sql statements to access the database engine?
What is a fill factor?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Which are the olap features?
Explain different types of Normalization.
Mention the different types of triggers?
If a table does not have a unique index, can a cursor be opened on it?
Write a SQL queries on Self Join and Inner Join.
What types of Joins are possible with Sql Server?
How to write character string constants or literals in ms sql server?
