How to use go command in "sqlcmd"?

0 Answers  

---

What is a heap?

0 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

List all types of constraints in sql server?

0 Answers  

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---

Explain what are the database objects? : SQL Server Architecture

0 Answers  

---

What is sql server programming?

0 Answers  

---

What are the advantages of passing name-value pairs as parameters?

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  

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

0 Answers  

---

Can we check locks in database? If so, how can we do this lock check?

0 Answers  

---

What are the different types of replication are there in sql server 2000?

0 Answers  

---