Answer / abhaymalviya

STUFF - Delete a specified length of characters and insert
another set of characters at a specified starting point.
For example: SELECT STUFF('asdfghjkl', 3, 5, 'XYZ')
Go
here the result set is:

asXYZkl

REPLACE - Replace all occurrences of the second given string
expression in the first string expression with a third
expression.
For Example: SELECT REPLACE('Abhay', 'a', 'KKT')
Here the result set is:

KKTbhKKTy

Answer / ruchi

STUFF - Delete a specified length of characters and insert
another set of characters at a specified starting point.
For example: SELECT STUFF('asdfghjkl', 3, 5, 'XYZ')
Go
here the result set is:

asXYZkl

REPLACE - Replace all occurrences of the second given string
expression in the first string expression with a third
expression.
For Example: SELECT REPLACE('Abhay', 'a', 'KKT')
Here the result set is:

KKTbhKKTy

What are the purposes of floor and sign functions?

0 Answers  

---

What is filestream?

0 Answers  

---

What does nvl stand for?

0 Answers  

---

Explain primary key, foreign key and unique key?

0 Answers  

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

0 Answers  

---

What is the datatype of rowid?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

0 Answers  

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

---

What are policy management terms?

0 Answers  

---

Explain the new features of SQL server 2000?

1 Answers  

---

What is row_number () and partition by in sql server?

0 Answers  

---