Answer / Rohit Saxena

{"answers":[n "REPLACE: Replaces a specified number of occurrences of a specified string with another string.n ",n "STUFF: Modifies a string expression by inserting a specified string value into a specified position within the source string."]}

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

---

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1 Answers  

---

Explain about thread and memory management process of SQL?

1 Answers  

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

1 Answers  

---

What are triggers? How do you invoke a trigger on demand?

1 Answers   Hexaware,

---

What is a performance monitor?

1 Answers  

---

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

2 Answers   IBM,

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

---

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,

---

What are the different authentication modes in sql server? How can it be changed?

1 Answers  

---

How do you fine the performance tunning?

2 Answers   Accenture,

---