Answer / anjana

Table test have one column as name:

Test
name
a
b
c
d
e
f
g

select replace(name,'e','f') from test order by name


Output will be:

a
b
c
d
f
f
g

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---

What are the different types of replication are there in sql server 2000?

0 Answers  

---

what is hash table

3 Answers   ILFS, Teledata,

---

Tell me about pre-defined functions of sql?

0 Answers   EXL,

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

0 Answers  

---

What happens if the update subquery returns no rows in ms sql server?

0 Answers  

---

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

How to create a view on an existing table in ms sql server?

0 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

Explain what are magic tables in sql server?

0 Answers  

---

What is a livelock?

0 Answers  

---

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---