Interested to Buy Any Domain ? << Click Here >> for more details...
Wht is Stuff in sql ser
- 2 Answers
- 5378 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 are the transaction properties?
What are exact numeric data types in ms sql server?
Explain having clause and where clause?
What are ddl (data definition language) statements for tables in ms sql server?
Where do we use trace frag?
What does it mean to be in union?
What's the purpose of Stored Procedure?
What is the function of inner join?
how to find the second salary?
Do you know how to store and query spatial data?
What are the restrictions applicable while creating views? : SQL Server Architecture
Which institute is best for SQL Server 2005 Training?
-
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)
