Urgent

1. Compare and explain the difference between the two statements.

Statement 1:

CREATE PROCEDURE Insert_data

AS

INSERT INTO StudentTest VALUES ('1', 'Peter', 'Gallert', 'Male')

EXECUTE Insert_data

Statement 2:

BEGIN

INSERT INTO StudentTest VALUES ('1', 'Peter', 'Gallert', 'Male')

END

2. Compare and explain the difference between the two statements.

Statement 1:

CREATE PROCEDURE Insert_data

@Data INT

AS

BEGIN

SELECT @Data = Student_no FROM StudentTest;

PRINT @Data

END

EXECUTE Insert_data '1'

Statement 2:

DECLARE @Data INT

BEGIN

SELECT @Data = Student_no FROM StudentTest;

PRINT @Data

END