SQL Archives - Coddicted

Truncate, Delete and Drop

Apr

16

2013

DELETE The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo ...

Triggers and Indexes

Apr

16

2013

Triggers SQL Triggers are SQL Statements or a set SQL of statements which is stored to be activated or fired when an event associating with a database table , view or schema occurs. The event can be INSERT, UPDATE and DELETE. SQL Triggers provides an alternative way to check integrity and to run scheduled tasks. However, ...

Stored Procedures and Functions

Apr

16

2013

Difference between Stored Procedures and Functions Stored procedures are a set of actions already written and stored inside database for achieving a particular task. Functions are general databse objects which are used for general purpose programming. S.No. Stored Procedures Functions 1. Procedures may return none or more values Functions must always return one value either a ...