What is indexing in sql server with example?

0 Answers  

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

Do you know hot add cpu in sql server 2008?

0 Answers  

---

What is logon trigger?

0 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers   HCL,

---

---

How to recover from sql injection? : sql server security

0 Answers  

---

What is a group function explain with an example?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

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 information schema views?

0 Answers  

---

What is set nocount on?

0 Answers  

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

---