Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why do we partition data?
What is the difference between upgrade and migration in sql server?
Explain an automatic checkpoint
Differentiate sql server reporting services vs. Crystal reports?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is the default value of an integer data type in sql server 2005?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
explain different types of joins? : Sql server database administration
Why we need to use secondry database file? though, we can do same work using primary database file also.
What are built in functions?
What is the correct order of the logical query processing phases?
How many clustered indexes there can be on table ?
Explain what are the basic functions for master, msdb, model, tempdb databases?
How to write an inner join with the where clause in ms sql server?
What is row_number function?
