Why foreign key column allowing null values even a parent tables reference key column not having null value..

2 Answers   IBM,

---

Why olap is used?

0 Answers  

---

What do you mean by collation recursive stored procedure?

0 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  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

---

Can a table be moved to different filegroup?

0 Answers  

---

What is sql injection and why is it a problem? : sql server security

0 Answers  

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

What is dynamic cursor in SQL SERVER?

0 Answers  

---

What are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

Which tcl commands are available on the sql server?

0 Answers  

---

What is the cpu pressure?

0 Answers  

---