Urgent

1.

Consider the following code, and please explain what the outcome will be:

ALTER Procedure [dbo].[DeleteStudentTransaction]@Id INT

AS

BEGIN TRY

BEGIN TRANSACTION

DELETE FROM Student WHERE Id=@Id

RAISERROR('Some Random Error',16,1)

COMMIT

END TRY

BEGIN

CATCH ROLLBACK

END CATCH

2.

The code below contains errors. Can you please correct the errors so that the procedure can execute successfully.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE PrintCustomers_Cursor

AS

BEGIN

SET NOCOUNT ON;

DECLARE @CustomerId INT

,@Name VARCHAR(100)

,@Country VARCHAR(100)

DECLARE Counter DATE

SET Counter = 1

DECLARE PrintCustomers READ_ONLY

FOR

SELECT CustomerId, Name, Country

FROM Customers

OPEN PrintCustomers

FETCH FROM PrintCustomers INTO

@CustomerId, @Name, @Country

WHILE @@FETCH_STATUS = 0

BEGIN

IF @Counter = 1

BEGIN

PRINT 'CustomerID' + CHAR(9) + 'Name' + CHAR(9) + CHAR(9) + CHAR(9) + 'Country'

PRINT '------------------------------------'

END

PRINT (@CustomerId AS VARCHAR(10)) + CHAR(9) + CHAR(9) + CHAR(9) + @Name + CHAR(9) + @Country

SET Counter = Counter + 1

FETCH FROM PrintCustomers INTO

@CustomerId, @Name, @Country

END

DEALLOCATE PrintCustomers

CLOSE PrintCustomers

END

GO