Explain DBCC?

0 Answers   QuestPond,

---

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

---

What is MSDE?

2 Answers  

---

Explain “not null constraint” in sql server?

0 Answers  

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

How create table structure only from tableA to TableB if TableA have some data?

4 Answers  

---

How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

---

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

---

Is it possible to create trigger on views?

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  

---

How to send email from database?

0 Answers  

---

how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,

---