What is the significance of master, tempdb and model databases?

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

what is bit datatype? : Sql server database administration

0 Answers  

---

What is the purpose of UPDATE STATISTICS?

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 the difference between a stored procedure and a user defined function?

0 Answers  

---

What does normalization do to data?

0 Answers  

---

What is mean by candidate key?

0 Answers  

---

What are the different Topologies in which Replication can be configured?

0 Answers  

---

How many types of built in functions are there in sql server 2012?

0 Answers  

---

What is raid? : SQL Server Architecture

0 Answers  

---

What do you understand by integration services in sql server?

0 Answers  

---