Answer / pradeep

Triggers in DB are analogus to the triggers in hand
grenades.
It are reffered a stored procedure call that initiates its
action on any event occures such as insert, update or
delete query.

Answer / shalini

trigger is a block of code that constitutes a set of T-sql
statements activated to response in certain action.

Answer / praveen ch

trigger is nothing but a logic, this logic like a stored
procedure and which is uesd to represented as before
updation of table or after updation of the table

thank u

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

What is used to replicate sessions between instances in coldfusion clusters?

0 Answers   HCL,

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,

---

How can a user-defined datatype be created?

0 Answers  

---

what is memory-optimized nonclustered indexes

0 Answers  

---

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers  

---

How will you find out if there are expensive SQL statements running or not?

0 Answers   Atos Origin,

---

What happens if time-only values are provided as date and time literals?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---