Interested to Buy Any Domain ? << Click Here >> for more details...
Wht is Stuff in sql ser
- 2 Answers
- 5442 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 the information that can be stored inside a bit column? : Sql server database administration
What is database white box testing?
How to create Clustered Primary Key to table?
Tell me what is a linked server?
What is the purpose of self join?
What are the steps to follow to configure SQL*Net?
What are transactions in sql?
where can you add custom error messages to sql server? : Sql server administration
what is the primary use of the model database? : Sql server administration
What is Left Outer Join?
How to turn off warning messages during php execution?
What is the difference between mysql and sql server?
-
Oracle (3253) - 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)
