0 0
9 views
The ‘magic tables’ are the INSERTED and DELETED tables,and Update SQL Server create magic tables to hold the values during the DML operations. basically, magic tables are used by triggers for the data transaction. ...

Please explain why do you think this question should be reported?

Report Cancel

0 0
9 views
Scheduling jobs is one of the core SQL Server functions.assignments or jobs are utilized to mechanize forms that can be kept running on a booked time at a regular interval.This scheduling of tasks helps to reduce human intervention. ...

Please explain why do you think this question should be reported?

Report Cancel

0 0
7 views
SQL Server supports two authentication modes, Windows authentication mode and mixed mode.Authentication mode enables Windows Authentication and disables SQL Server Authentication.Mixed mode enables both Windows Authentication and SQL Server Authentication. ...

Please explain why do you think this question should be reported?

Report Cancel

0 0
10 views
Single row subquery : Returns zero or one row. Multiple row subquery : Returns one or more rows. Multiple column subqueries : Returns one or more columns. Correlated subqueries : Reference one or more columns in the outer SQL statement. ...

Please explain why do you think this question should be reported?

Report Cancel

0 0
8 views
Four types of triggers and they are as follow. Insert Delete Update Instead of Please follow and like us:...

Please explain why do you think this question should be reported?

Report Cancel

0 0
9 views
An error condition during a program execution is called an exception and the mechanism for resolving such an exception is known as an exception handler. SQL Server provides TRY, CATCH blocks for exception handling. ...

Please explain why do you think this question should be reported?

Report Cancel

0 0
8 views
A global temporary table is created using CREATE TABLE statement with the table name prefixed with a double number sign (##table_name).Scope will be the outside the session while nearby brief tables are inside the session. Session ID can be discovered ...

Please explain why do you think this question should be reported?

Report Cancel

0 0
12 views
A trigger is a special type of stored procedure that automatically executes when an event occurs in the database server.Triggers are automatically triggered or executed when the data is modified.triggers are executed when a DML operation like INSERT, UPDATE OR ...

Please explain why do you think this question should be reported?

Report Cancel