sql ´æ´¢¹ý³Ì¼òµ¥Ð´ - MS-SQL Server / »ù´¡Àà

ÌâÄ¿ÊÇ ´´½¨Ò»¸ö´æ´¢¹ý³Ì£¬¹¦ÄÜÊǸù¾ÝÊäÈëµÄ²ÎÊýÐÎʽ¸ø¶¨µÄѧÉú´Ó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£¬Ã»¿´ºÃ£¬×Ô¼ºÈ¥µô
{{