Answer Posted / 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

What are various aggregate functions that are available?

504

---

How to use transact-sql statements to access the database engine?

537

---

What is the web service used for reporting services?

98

---

What is the use of sql profiler in sql server 2012?

510

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

612

---

---

What is SQL Server?

663

---

How to create a local temporary stored procedure?

499

---

When a primary key constraint is included in a table, what other constraints does this imply?

597

---

Mention the different authentication modes in sql server.

532

---

What is always encrypted?

516

---

What is "scheduled jobs" or "scheduled tasks"?

552

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

567

---

User wants only to display only pdf as export option in report manager. How to achieve this?

173

---

How many clustered indexes there can be on table ?

598

---

What is the cartesian product of table?

542

---