Wht is Stuff in sql ser
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 |
Explain basic SQL queries with SELECT from where Order By, Group By-Having?
Difeerence between ssis 2005 and ssis2008?
What is subquery in sql?
If we delete pack Spec what will be the status of pack Body ?
explain different types of backups avaialabe in sql server? : Sql server database administration
Can you roll back the ddl statement in a trigger?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Why I am getting this error when renaming a database in ms sql server?
What is table constraint?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
Write SQL queries on Self Join and Inner Join.
What are binary string data types in ms sql server?
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)