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 to get last system shutdown time in Sql server when restarted system?

1 Answers  

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

Why truncate is ddl command?

0 Answers  

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  

---

What is database isolation in sql server? : sql server database administration

0 Answers  

---

What is the parse query button used for?

0 Answers  

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  

---

What are pages and extents? : SQL Server Architecture

0 Answers  

---

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

---

What is blocking?

0 Answers  

---

Can you index views?

0 Answers  

---