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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!