ÌâÄ¿ÊÇ ´´½¨Ò»¸ö´æ´¢¹ý³Ì£¬¹¦ÄÜÊǸù¾ÝÊäÈëµÄ²ÎÊýÐÎʽ¸ø¶¨µÄѧÉú´Óxs,kcºÍxk±íÖвéѯ³öÕâЩѧÉúµÄѧºÅÐÕÃûºÍËùÑ¡¿Î³ÌµÄ¿Î³ÌÃûºÍ³É¼¨
create proc test_proc2
as
select xs.xh,xsxm,kcm,cj from xs,kc,xk
exec test_proc2 ' ',' ',' ',' ' --''ÀïµÄ¾ßÌå²ÎÊýÎÒûд
´´½¨Ò»¸ö´æ´¢¹ý³Ì£¬¸ù¾ÝÒѾÊäÈë²ÎÊýÐÎʽ¸ø¶¨µÄѧÉúµÄѧºÅͳ¼Æ³ö¸ÃѧÉúËùÑ¡µÄ¿Î³ÌµÄƽ¾ù³É¼¨£¬²¢ÓÐÊä³ö²ÎÊý´ø»ØÆäƽ¾ù³É¼¨
create pro test_proc3
@xsxh char
as
select avg(cj) from xk where xh=@xsxh group by kch
print cj
exec '050202104'
ÕâÑù¿ÉÒÔÂ𣿣¿
SQL code:
create pro test_proc3
@xsxh varchar(20),
@cj numeric(8,2) output
as
select @cj=avg(cj) from xk where xh=@xsxh
go
--µ÷ÓÃ
declare @n numeric(8,2)
exec test_proc3 '050202104',@cj=@n output
select @n
SQL code:
--1.
create proc test_proc2
@²ÎÊý ²ÎÊýÀàÐÍ
as
select xs.xh,xsxm,kcm,cj from xs,kc,xk where Á¬½ÓÌõ¼þ and ²ÎÊýÁÐÃû=@²ÎÊý
GO
exec test_proc2 ' ',' ',' ',' ' --''ÀïµÄ¾ßÌå²ÎÊýÎÒûд
--2.
create pro test_proc3
@xsxh varchar(20),
@avgcj int out
as
select @avgcj=avg(cj) from xk where xh=@xsxh group by kch
GO
declare @avgcj int
exec '050202104',@avgcj out
print @avgcj
µÚ¶þ¸ö²»ÓÃgroup by kch£¬Ã»¿´ºÃ£¬×Ô¼ºÈ¥µô
{{