±àдһ¸ö³ÌÐò¸ù¾ÝÄêÁäÅжÏÒ»¸öÈËÊDz»ÊǶùͯ(ÉèÒ»¸öÈ˵ÄÄêÁäÉÙÓÚ10ËêΪ¶ùͯ)
declare @age int
set @age=1
if @age<10
print '¶ùͯ'
else
print '²»ÊǶùͯ'
ÇëÎÊ¿ÉÒÔ×Ô¼ºÊäÈëageÂð£¿
ÎÒ²»ÖªµÀSQL Óï¾ä±à³ÌÓмüÅÌÊäÈëµÄÂ𣨱ÈÈçCÓïÑÔÖеÄscanf)
ûÓС£
µÄÈ·ÊÇûÓмüÅÌÊäÈëµÄ
д´æ´¢¹ý³Ì °Ñageµ±¸ö²ÎÊý´«²¼¾ÍÐÐÁË
create proc s
@age int
as
if @age<10
print '¶ùͯ'
else
print '²»ÊǶùͯ'
exec s '9'
ûÓÐ..
¿¿£¬¡¡°Ñ£ó£ñ£ìµ±±à³ÌÓïÑÔÁË¡£¡¡
¡¡£ó£ñ£ì£½¡¡£ó£ô£ò£õ£ã£ô£õ£ò£å¡¡£ñ£õ£å£ò£ù¡¡£ì£á£î£ç£õ£á£ç£å¡¡
¿ÉÒÔʹÓô洢¹ý³Ìѽ
ÈçÏ£º
SQL code:
create proc prcIsChild
@age int
as
begin
if @age<10
print '¶ùͯ'
else
print '²»ÊǶùͯ'
end
ÒýÓà ¿ÉÒÔʹÓô洢¹ý³Ìѽ ÈçÏ£º SQL code create proc prcIsChild @age int as begin if @age<10 print '¶ùͯ' else print '²»ÊǶùͯ' endÄÇÈç¹ûд´æ´¢¹ý³ÌÒªÇóÊäÈë²ÎÊý°ÑѧÉú´Óxs,kcºÍxk±íÖвéѯ³öÕâЩѧÉúѧºÅÐÕÃû£¬ÒÔ¼°ËùÑ¡µÄ¿Î³ÌÃûºÍ³É¼¨
ÕâÑùд¶ÔÂð£¿
create proc test_proc2
as
select xs.xh,xsxm,kcm,cj from xs,kc,xk
exec test_proc2 ' ',' ',' ',' ' --¡® ¡¯ÀïÃæÊÇд¾ßÌåµÄ²ÎÊý£¬ÎÒûд
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡ Ëæ±ã¸ãÒ»D°æ°É£¬ ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓà 2000,2005¶¼ÕâÑù http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ ÖÁÉٵø½¼Óµ½sqlserverÉÏ ¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿ Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£ sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
select o_customer,o_price from orders having o_price >=avg(o_price) select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders) ÎҸоõûÓÐÇø±ð°¡£¬ÔõôÔÚmysql»áÓÐ ......
ÎÒÓÐÒ»¸ö×Ö¶ÎÊÇ varchar(1) ÀàÐÍ£¬¶þ½øÖƱíʾҲ¾ÍÊÇ8λµÄ ¡®0000 0000¡¯ ±ÈÈçÕâ¸öʱºòÎÒÐèҪɸѡ³öÕâ¸ö×Ö¶ÎΪËùÓÐµÄ ¡®0000 0100¡¯µÄÐУ¬ÇëÎÊSQLÄÜʵÏÖÕâÑùµÄ¡°Î»¡±µÄɸѡÂ𣿠лл~~~ ÓÐλ²Ù×ݺ¯ÊýÂ𣿲»ÐоÍ× ......