Interested to Buy Any Domain ? << Click Here >> for more details...
Wht is Stuff in sql ser
- 2 Answers
- 5242 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is transactional replication?
Can anybody explain me cold backup and hot backup?
What are the two virtual tables SQL Server maintains for triggers?
Other than truncate statement, which other command can by-pass the trigger on the tables?
How to create a local temporary stored procedure?
What are the requirements to use odbc connections in php scripts?
What are functions in the sql server?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What is a performance monitor?
What is delete query?
What command would you use to add a column to a table in sql server?
Explain the concept of recursive stored procedure.
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
