Question: 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
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
