下面是创建存储过程的示例代码:
CREATE PROCEDURE Pro_getStu
(
@departmentName varchar(50),
@startDate date,
@endDate date
)
AS
BEGIN
SELECT * FROM students
WHERE department = @departmentName AND birthdate BETWEEN @startDate AND @endDate
END
下面是创建存储过程的示例代码:
CREATE PROCEDURE Pro_getStu
(
@departmentName varchar(50),
@startDate date,
@endDate date
)
AS
BEGIN
SELECT * FROM students
WHERE department = @departmentName AND birthdate BETWEEN @startDate AND @endDate
END