Select from following answers:- Adds a new row to the Emp table, and also adds a corresponding row with the current date and time and the EmpId for the new employee into the Audit table.
- Only inserts a new record into the Emp table.
- OUTPUT clause cannot be used in the INSERT command
- Error
- All Above
OUTPUT getdate(), inserted.EmpId INTO Audit
means current date & time and empid which is inserted into original table "Emp" will also be inserted into Audit table
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator