Name the triggers which support SQL Server 2000
Name the triggers which support SQL Server 2000?
Expert
SQL Server 2000 supports AFTER and INSTEAD OF triggers only. The BEFORE triggers cannot be supported by any SQL server. A table might have one or more AFTER triggers for update, insert and delete actions; AFTER triggers might not be assigned to views. A view or table might have at most one INSTEAD OF trigger for each and every triggering action of update, insert or delete.
Describe the difference between a regular sub query and a correlated sub query?
Illustrates the way to save space while inserting rows monotonically?
States the term Mirror Activator Disk mirroring?
Specify the use of data stage designer?
What demerits of ODBC does OLE DB overcome?
Write about the components of the Ascential Data Stage?
Illustrate out some of the standard Business Intelligence tools in the market?
Differentiate between Multiload and Fastload in terms of Performance?
Describe some of the major objectives of normalization?
Explain several of the products of Sybase?
18,76,764
1934117 Asked
3,689
Active Tutors
1433204
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!