Answer Posted / 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 |
Post New Answer View All Answers
What is the use of “join” in sql server?
What is schemabinding a view?
What happens if null values are involved in arithmetic operations?
How to fine-tune reports?
What is table-valued sub query?
Does a server store data?
What is table value parameters (tvp)?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is the difference between cartesian product and cross join?
Can we use where clause in union?
What do you mean by cardinality?
What is SQL Azure Fabric?
Explain relational data?
How to count groups returned with the group by clause in ms sql server?
Define views.
