What is a cube? : sql server analysis services, ssas

0 Answers  

---

Does view occupy space?

0 Answers  

---

What are sql server functions?

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  

---

Characterize join and name diverse sorts of joins?

0 Answers  

---

---

What is @@Identity in sql?

1 Answers   Cap Gemini,

---

two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,

---

What is query and its types?

0 Answers  

---

What is the difference between Procedure and Function

4 Answers   Accenture, Nagarro, TCS,

---

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

---

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

---

how can you attach more than 20 ldf files in sql server

0 Answers   IBM,

---