Explain about nested stored procedure?

0 Answers  

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  

---

What is openrowset sql server?

0 Answers  

---

What is the dbcc command and why is it used?

0 Answers  

---

How to connect to a sql server using odbc_connect()?

0 Answers  

---

What is microsoft sql server?

0 Answers  

---

What is the standby server?

0 Answers  

---

Which are the important points to note when multilanguage data is stored in a table?

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  

---

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

2 Answers   IBM,

---

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

---

Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,

---