SQL Server進階（四）預存程序

標籤：bsp   else   procedure   style   RoCE   from   color   sele   class   

建立預存程序

Create PROCEDURE [dbo].[p_test]    @type intASBEGIN    declare @count int    if(@type =1)        begin            select  @count = (select count(*) from dbo.UserGrowthDetail)            print @count            return @count        end    else if(@type =2)        begin            select  @count = (select count(*) from dbo.UserGrowthValue)            print @count            return @count        endEND

執行預存程序

GODECLARE    @return_value intEXEC    @return_value = [dbo].[p_test]        @type = 1SELECT    ‘Return Value‘ = @return_valueGO

 

SQL Server進階（四）預存程序