MSSQLストレージプロセス(長い間のメモ、思い出して)

構文:

create proc  



      



     as



      

呼び出し:

exec    

要点:

1. output 

2. ， 

例:

 1 --   procedure

 2 create proc tri

 3 @str varchar(10)

 4 as

 5 declare @str1 varchar(10)

 6 set @str1=LTRIM(RTRIM(@str))

 7 print @str1

 8 

 9 -- ：exec

10 exec tri ' abc '    

11 --   output

12 -- 

13 create proc suml

14 @num1 int ,

15 @num2 int,

16 @result int output -- 

17 as 

18 set @result=@num1+@num2

19 

20 declare @r int

21 exec suml 1,2,@r output  -- output ， 

22 print @r

23 

24 -- ，Ps: 

25 alter proc multi

26 @num1 int,

27 @num2 int=10 output --output  c# ref 

28 as 

29 set @num2=@num2*@num1

30 print @num2

31 -- 

32 declare @num int=2

33 exec multi 3,@num output

34 select @num

35 

36