Explain what is the purpose of sql profiler in sql server?

0 Answers  

---

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

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

2 Answers   IBM,

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

What is the purpose of the tempdb database?

0 Answers  

---

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

0 Answers  

---

What are the different editions available in sql server 2000?

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

---

How to create and drop temp table in sql server?

0 Answers  

---

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

---

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 does the update command do?

0 Answers  

---