34,590
社区成员
发帖
与我相关
我的任务
分享
DELIMITER $$
CREATE
PROCEDURE `njue`.`pr_getAllProvider`()
BEGIN
select * from tb_provider where available!=0;
END$$
DELIMITER ;
DECLARE @return_value int --返回值
EXEC @return_value = [dbo].[MyProcedure] --执行存储过程
SELECT 'Return Value' = @return_value --输出返回结果
CREATE PROCEDURE proc_name
AS
BEGIN
SET NOCOUNT ON;
select * from tb_provider where available!=0;
END
GO
CREATE PROCEDURE pr_getAllProvider
BEGIN
select * from tb_provider where available!=0
END
create proc dbo.pr_getAllProvider
as
select * from tb_provider where available!=0;
go
--调用
exec dbo.pr_getAllProvider