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 to know whether our backup is succesfully taken?

1 Answers  

---

How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  

---

What is the difference between the 2 operating modes of database mirroring?

0 Answers  

---

What is an index?

8 Answers   Yardi Software,

---

What is the cartesian product of table?

0 Answers  

---

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

What is collation sensitivity? Explain different types.

0 Answers  

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

---

How to verify the port number of the sql server?

0 Answers  

---

What are the different normalization forms?

0 Answers  

---