I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

What do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

---

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

What is the difference between executequery () and executeupdate ()?

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 stored by the model?

0 Answers  

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---

Explain the properties of sub-query in sql server?

0 Answers  

---

What is a data source file?

0 Answers  

---

How is sql server used?

0 Answers  

---