Interested to Buy Any Domain ? << Click Here >> for more details...
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 a file group?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What is difference between order by and group by?
What are trace files?
What are acid properties of transaction?
What are the advantages of sql azure?
Does order by actually change the order of the data in the tables or does it just change the output?
List some case manipulation functions in sql?
How to delete duplicate rows?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What are the steps you can take to avoid “deadlocks”?
How do I partition a table in sql server?
Does an index slow down updates on indexed columns?
How to list all field names in the result set using mssql_field_name()?
