Ví dụ PROCEDURE trả về 1 bảng dữ liệu.
CREATE PROCEDURE [dbo].[pr_TEST_1]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
Select * From tbKhuVuc
END
Ví dụ PROCEDURE trả về 1 giá trị
** Chỉ trả về được kiểu số.
CREATE PROCEDURE [dbo].[pr_TEST_2]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
Return 1
END
Declare @kq int
Exec @kq=[dbo].[pr_TEST_2]
select @kq