Answer / bhaskar

Function can excute by the SELECT statement
ex SELECT Functionname(parameters), select *from
functionname

select s_func(Parameters)

We cant execute the trigger ,
When we perform a DML(DELETE,INSERT,UPDATE) operation
Trigger will fire automatically

What is xdr?

0 Answers  

---

How to change the ownership of a schema in ms sql server?

0 Answers  

---

What is the query and subquery?

0 Answers  

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

---

How do I clean up sql server transaction log?

0 Answers  

---

---

Explain a checkpoint?

0 Answers  

---

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

---

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

---

What is difference between clustered and non clustered index?

0 Answers  

---

How to read 2nd highest sal from EMP table?

5 Answers   IBM, TCS,

---

How to execute stored procedure and set temp table in sql server?

0 Answers  

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---