What is primary key, unique key, and foreign key?

0 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What does the automatic recovery do?

1 Answers  

---

What is xdr?

0 Answers  

---

SQL Server Architecture ?

0 Answers   IBM, Sapient,

---

How to swap the data of two columns in a table. both the columns containing varchar values.

9 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  

---

Write a SQL query to make a column as unique?

0 Answers   Cap Gemini,

---

What is the partitioning method?

0 Answers  

---

What are the differences between union, intersect, and minus operators?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---