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 can we check the sql server version?

0 Answers  

---

How do you clear a log file?

0 Answers  

---

Explain cursor as data base object?

0 Answers  

---

What is clustered primary key?

0 Answers  

---

What is bit data type? What's the information that can be stored inside a bit column?

0 Answers  

---

What is function of ROLLUP ?

0 Answers   HCL,

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

List out different types of normalizations in sql server and explain each of them?

0 Answers  

---

Does partitioning improve performance?

0 Answers  

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

0 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---