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 are a database and a data warehouse?
What is the purpose of object explorer and its features? : sql server management studio
How to list all field names in the result set using mssql_field_name()?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
How do you delete a data source?
What are the source of constraints?
Can one drop a column from a table?
What is the use of “join” in sql server?
How to create a testing table with test data in ms sql server?
What is local temp table?
Why truncate is ddl command?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Explain the relational database management system (rdbms)?
how to trace the traffic hitting a sql server? : Sql server database administration
Explain datetimeoffset data type in sal server 2008?