Answer / Rina Kumari

Dropping an object (e.g., table, view, stored procedure) permanently removes it from the database. On the other hand, taking an object offline makes it temporarily unavailable for queries or transactions but keeps the structure intact. Taking an object online makes it accessible again.

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

what is cluster and nin-cluster index?

4 Answers  

---

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 Answers  

---

What are orphan records?

1 Answers  

---

Why we use trigger in sql server with example?

1 Answers  

---

What are xml indexes?

1 Answers  

---

What will be the maximum number of indexes per table?

1 Answers  

---

What are the joins in sql server? : sql server database administration

1 Answers  

---

Which are the third-party tools used in sql server and why would you use them?

1 Answers  

---

What are transactions and its controls?

1 Answers  

---

What is data source object?

1 Answers  

---