A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are stored in and managed by the DBMS.Triggers are used to maintain the referential...
View in SQL is a virtual table.It is possible to add SQL functions ,WHERE and JOIN statements to a view.This will help in presenting the data as if coming from a single table.It is possible to update...
Hi Everybody,
I am Vijay.According 2 me the differences are:
1. In SQL Server 2000 the Query Analyzer and Enterprise Manager are seperate,whereas in SQL Server 2005 both were combined as Management...
The list of changes is too long to type so here is a website that has everything you ned to know:http://www.eweek.com/c/a/Database/Change-Is-Good-for-SQL-Server-2005/