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

mysql´æ´¢¹ý³Ì - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÔÚmysql´æ´¢¹ý³ÌÖж¨Òå±äÁ¿ºÍ²ÎÊýʱ¿ÉÓпÉÎÞ·ûºÅ@£¬ÇëÎÊÓÐ@ºÍûÓÐ@ÓÐÊ²Ã´Çø±ð£¿Ð»Ð»£¡

create procedure mypro()
begin
declare @temp int;
set @temp=3;
end //
´´½¨Õâ¸ö´æ´¢¹ý³ÌµÄʱºòΪʲô»á±¨´íÄØ£¿

Èç¹ûÉÏÃæÕâ¸ö´æ´¢¹ý³ÌÖв»¼Ó@·ûºÅ£¬´æ´¢¹ý³ÌÄÜÕý³£´´½¨£¬ÕâÊÇÎªÊ²Ã´ÄØ£¿


declare @temp int;

Äã²»¿ÉÒÔdeclare Ò»¸ö session ±äÁ¿¡£

create procedure mypro(IN @temp int)
begin
select * from t where t.id>@temp;
end//
ÄÇÇëÎÊÕâÑù´´½¨´æ´¢¹ý³Ìmypro»á±¨´íÓÖÊÇÎªÊ²Ã´ÄØ£¿£¨È¥µô@¿ÉÒÔ´´½¨³É¹¦£©

ÒýÓÃÄã²»¿ÉÒÔdeclare Ò»¸ö session ±äÁ¿¡£


ÄãÒªÌýÂ¥ÉÏÀÇÐֵϰ£¬×Ô¶¨Òå±äÁ¿²»Òª¼Ó@


Ïà¹ØÎÊ´ð£º

mysql×Ö¶ÎÌáÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......

vs2008 Á¬½Ómysql£¿ - MS-SQL Server / »ù´¡Àà

ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐË­ÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿

ÒýÓÃ
ÇëÎÊ
......

PHP+MYSQLÊý¾Ý¼¯´¦Àí - PHP / »ù´¡±à³Ì

1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......

mysqlÇøÃ»¸ßÊÖ - MS-SQL Server / »ù´¡Àà

ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......

mssqlº¯Êý·­Òë - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¹òÇó½«ÒÔϺ¯Êý·­ÒëΪ mysql µÄÓï·¨
CREATE FUNCTION workdayadd( 
@date datetime, --»ù´¡ÈÕÆÚ 
@workday int --ÒªÔö¼ÓµÄ¹¤×÷ÈÕÊý 
)RETURNS datetime 
AS 
BEGIN 
DEC ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ