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

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---

Can sql servers linked to other servers like oracle?

0 Answers  

---

Equi join and non equi join is possible with sql server?

0 Answers  

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

---

How you can get a list of all the table constraints in a database?

0 Answers  

---

Explain view in sql server?

0 Answers  

---

Differentiate between a having clause and a where clause.

0 Answers  

---

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

---

What are the advantages of using a stored procedure?

0 Answers  

---

What methods do you follow to protect from sql injection attack?

0 Answers  

---

Explain query editor regions

0 Answers  

---