Câu 49: 70-461: MCSA Querying Microsoft SQL Server 2012/2014

You are developing a Microsoft SQL Server database for a company. The database contains a table that is defined by the following Transact-SQL statement: You use the following Transact-SQL script to insert new employee data into the table. Line numbers are included for reference only. If an error occurs, you must report the error message and line number at which the error occurred and continue processing errors. You need to complete the Transact-SQL script. Which Transact-SQL segment should you insert at line 06?

1. A. SELECT ERROR_LINE(), ERROR_MESSAGE()
2. B. DECLARE @message NVARCHAR(1000),@severity INT,@state INT; SELECT @message = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE(); RAISERROR (@message, @severity, @state); — đáp án hiện tại
3. C. DECLARE @message NVARCHAR(1000),@severity INT, @state INT; SELECT @message = ERROR_MESSAGE(), @severity =ERROR_SEVERITY(), @state = ERROR_STATE(); THROW (@message, @severity, @state);
4. D. THROW;