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 |
can a database be shrunk with users active? : Sql server administration
Can we insert data if clustered index is disabled?
What should we do to copy the tables, schema and views from one SQL Server to another?
What is the size of transaction log file?
How to reaname table name without using sp_Rename in sql server..?
What is Cross Join
Define self join in sql server joins?
Explain active/passive and active/active cluster configurations?
How to insert multiple rows with a subquery?
Find columns used in stored procedure?
What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query
What is an index in sql?
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)