Answer / priyanka rani

By using Update statement. For example Update table_name set column_name='value' where column_name='your condition'
if required use where condition

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

What is a domain constraint give an example?

1 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1 Answers  

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

How to provide Security for package?

1 Answers   Convergys,

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---

What is database black box testing?

1 Answers  

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1 Answers  

---

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

1 Answers   Hexaware,

---