Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql Óï¾äд³ÌÐò£¬¸ÕÈëÃÅ - MS-SQL Server / »ù´¡Àà

±àдһ¸ö³ÌÐò¸ù¾ÝÄêÁäÅжÏÒ»¸öÈËÊ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 ' ',' ',' ',' ' --¡® ¡¯ÀïÃæÊÇд¾ßÌåµÄ²ÎÊý£¬ÎÒûд


Ïà¹ØÎÊ´ð£º

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......

asp wap sqlÓï¾äÖлñÈ¡µÄºº×Ö²»ºÃÊ - Web ¿ª·¢ / ASP

SQL code:

rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......

SQLÓï¾ä OR ´æ´¢¹ý³Ì£¿ - .NET¼¼Êõ / C#

Ö´ÐÐÊý¾Ý¿â²Ù×÷ʱ£¬Ö±½ÓÓÃSQL Óï¾äºÃһЩ »¹ÊÇÓô洢¹ý³Ì¸ü¼ÑÄØ£¿
¸÷ÊãÆð¼û
Õâ¸öµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö
¼òµ¥µÄselect ¡¢updateºÍinsertµ±È»sql½â¾öÁË
¸´ÔӵķÅÔÚsql·þÎñ¶ËÓ¦¸ÃºÃµã

Â¥Ö÷Çë²ÎÔÄ
http://msdn.micr ......

¹ØÓÚsql×÷ÒµÈÕÖ¾¼Ç¼ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÎÒµÄ×÷ÒµÊÇÿ·ÖÖÓÖ´ÐÐÒ»´Î
ʱ¼ä³¤ÁË»áºÜ´óÂð£¿Ó°ÏìsqlµÄÔËÐÐÂð£¿
ÓÐʲôÓÅ»¯°ì·¨Âð£¿
-- ÄÇÒª¿´ÄãÊÇʲôÑùµÄ×÷ÒµÂÔÚÓÅ»¯µÄͬʱÄÜ·ñÂú×ãÄãµÄ¾ßÌåÐèÇóÂ

-- ¾¡ÎÊһЩ¹ÖÎÊÌ⣬ҲÀµµÃ°ÑÎÊÌâ˵¾ßÌåÒ»µã£¬µ±È˼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ