Question: Question 1 Compare and explain the difference between the two statements. Not yet answered Statement 1: Marked out of 2.00 CREATE PROCEDURE Insert_data Flag question


Question 1 Compare and explain the difference between the two statements. Not yet answered Statement 1: Marked out of 2.00 CREATE PROCEDURE Insert_data Flag question AS INSERT INTO StudentTest VALUES ('1', 'Peter', 'Gallert', 'Male') EXECUTE Insert_data Statement 2: BEGIN INSERT INTO StudentTest VALUES ('1', 'Peter', 'Gallert', 'Male') END Question 3 Consider the following code, and please explain what the outcome will be: Not yet answered Marked out of 3.00 ALTER Procedure [dbo]. [Delete StudentTransaction]@ld INT P Flag question AS BEGIN TRY BEGIN TRANSACTION DELETE FROM Student WHERE Id=@ld RAISERROR('Some Random Error',16,1) COMMIT END TRY BEGIN CATCH ROLLBACK END CATCH
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
