Answer Posted / 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 |
Post New Answer View All Answers
Explain how many types of relationship?
How many types of stored procedures are there in sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Write query to return all rows sql?
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
What's the information that can be stored inside a bit column?
What is the difference between online clustering and Offline clustering?
Do you know clustered and non-clustered index?
What is snapshot replication?
How much is a sql server license?
What is the recommended total size of your memory optimized tables?
What is the security model used in sql server 2005?
What does Master database contains?
Explain time data type in sal server 2008?