How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,

---

Do you know what are the ways available in sql server to execute sql statements?

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 is package and it uses and how can u call a package

0 Answers   Satyam,

---

what purpose does OPENXML clause have in sql server stored procedure?

1 Answers  

---

How do I find the sql server database version?

0 Answers  

---

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

0 Answers  

---

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

---

Explain raiserror in sql server?

0 Answers  

---

Explain user defined functions?

0 Answers  

---

What is lookup override?

0 Answers   Informatica,

---