Answer Posted / ramesh

stored procedure:

Group of sql statements compiled into single execution plan.

create procedure sp_procedurename
as
begin
begin transaction
select * from table

if @@error=null
commit

else
rollback

end

Trigger
--------

Trigger is a set of sql queries which fire when an event
occurs(delete,update,insert).

in 2005 DDL TRIGGER INTRUDUCED.

What are a scheduled jobs or what is a scheduled tasks?

945

---

What are the differences between web role and worker role?

124

---

What is an sql server agent?

1114

---

In case you have filters in your report, when filters will be applied in cached report instance?

119

---

What are the different index configurations a table can have?

1009

---

What is co-related sub query?

1073

---

How will you hide an attribute? : sql server analysis services, ssas

1012

---

Do you have any idea about the tcl commands?

1015

---

How to rename databases in ms sql server?

1260

---

How to edit table in sql server 2017?

981

---

List out the different types of locks available in sql server?

1028

---

What are built in functions?

1068

---

What is the cartesian product of the table?

1005

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1030

---

How to provide values to user defined function parameters?

1063

---