Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

---

What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

---

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 ms sql server service broker?

0 Answers  

---

How to use subqueries in the from clause in ms sql server?

0 Answers  

---

What stored by the model? : sql server database administration

0 Answers  

---

What are logical/boolean operations in ms sql server?

0 Answers  

---

What is a dbms wizard?

0 Answers  

---

What is the difference between mysql and mysqli?

0 Answers   HCL,

---

Explain the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

Can we use trigger new in before insert?

0 Answers  

---

How can you list all the table constraints in a database?

0 Answers  

---