Write an sql query to find first weekday of the month?

0 Answers  

---

How to truncate a table first before running a package?

1 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

---

How do you create a data source?

0 Answers  

---

Do you know what is sql injection?

0 Answers  

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

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  

---

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

What is Trace flag?

1 Answers   Wipro,

---

How many categories of data types used by sql server?

0 Answers  

---

How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,

---

How to create an multi-statement table-valued function?

0 Answers  

---