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
Does sql server 2000 clustering support load balancing?
What are parameterized reports? What are cascading parameters in ssrs reports?
Explain how you can configure a running aggregate in SSRS?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What is the use of partition by in sql server?
what is a transaction and what are acid properties? : Sql server database administration
What are the different types of columns types constraints in the sql server?
What is db stored procedure?
Difference between DELETE and TRUNCATE?
Tell me what is the significance of null value and why should we avoid permitting null values?
What is difference between views and stored procedures?
What is ms sql server triggers?
Explain foreign key in sql server?
How to find out the list schema name and table name for the database?
How to create a simple user defined function in ms sql server?