Answer / bhaskar

Cursor is an Database object and retrive the rows from
database row by row ,
And it is maily use for ot reduce the network traffic
it contains 5 features
1.DECLARE the Cursor
2.OPEN the cusrsor
3.FETCH the cursor
4.CLOSE the cursor
5.DEALLOCATE the cursor

TRIGGER : IT is also an database object and You can
perform an anction Trigger will fire automatacallly.
like (DML,DDL)
They can cascade changes through related tables in the
database; however, these changes can be executed more
efficiently using cascading referential integrity
constraints.

They can guard against malicious or incorrect INSERT,
UPDATE, and DELETE operations and enforce other
restrictions that are more complex than those defined with
CHECK constraints.

Multiple DML triggers of the same type (INSERT, UPDATE, or
DELETE) on a table allow multiple, different actions to
take place in response to the same modification statement.

Answer / sanjay kumar dinda

Cursor is a database object used by applications to
manipulate data in a set on a row-by-row basis, instead of
the typical SQL commands that operate on all the rows in
the set at one time.


Trigger is a database object invoked automatically when any
event occured.
These aevents are
Delete, Insert, Update etc....

SQL server store the intermediate data into to dummy table
INSERTED and DELETED...

At the time of insert operation SQL Server STores inserted
rows into the INSERTED table and at the time of delete or
update SQL Server stores the information into DELETED dummy
table

Answer / adisha

CURSOR:
1.They are temporary work areas.
2.They are not stored independently in the database.
3.We can create cursor both implicitly and explicitly.
4.Cursors can take parameters.
5.They are used to process the result of query.

TRIGGER:
1.They are named PL SQL blocks.
2. They are stored in database.
3. They can be invoked automatically.
4. They cannot take parameters.
5. They are used to enforce data in dignity rules.

How do I connect to sql server database?

0 Answers  

---

wht is normalization?can u explain me in detail?

9 Answers   TCS,

---

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

0 Answers   TCS,

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  

---

How do we return a record set from a Stored Procedure in SQl server 2000?

3 Answers  

---

What is meant by indexing files?

0 Answers  

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

Can anybody explain me cold backup and hot backup?

3 Answers   TCS,

---

What is self contained sub query?

0 Answers  

---

What are the dis_advantages of stored procedures, triggers, indexes?

0 Answers  

---

Explain user defined functions?

0 Answers  

---