Answer / kinthada cnu

hi all

Trigger nothing but special kind of stored procedure
it's providing security to table data.And it is automatically
fire when the queary excuted.

ex:
create trigger <trigger name>
on <table name>
for <insert/update/delete>
as
begin
<statments>
end

How is sql used in sql server?

0 Answers  

---

What is the use of for clause?

0 Answers  

---

What does it mean if @@cursor_row returns a negative number?

0 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

---

Explain “not null constraint” in sql server?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

What is efficiency data?

0 Answers  

---

What is indexing explain it with an example?

0 Answers  

---

What is nolock?

0 Answers  

---

How to handle error or exception in sql?

0 Answers  

---

What are the benefits and tasks of object explorer? : sql server management studio

0 Answers  

---