What is difference between temp table and cte?

0 Answers  

---

What is rolap and its advantage? : sql server analysis services, ssas

0 Answers  

---

What kind of problems occurs if we do not implement proper locking strategy?

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 happens if null values are involved in arithmetic operations?

0 Answers  

---

What is row_number () and partition by in sql server?

0 Answers  

---

What is the difference between having and where clause?

4 Answers  

---

What stored procedure would you use to view lock information?

0 Answers  

---

What is intellisense?

0 Answers  

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

What is shared lock?

0 Answers  

---

Explain what are magic tables in sql server?

0 Answers  

---