What do you do in data exploration

0 Answers   EXL,

---

CREATE a table from another table

2 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 is difference between having and where clause ?

3 Answers  

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

What is dml command?

0 Answers  

---

What is a schema in ms sql server 2005?

0 Answers  

---

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

---

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,

---

What is the stuff?

0 Answers  

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

---

What is the recursive stored procedure in sql server?

0 Answers  

---