Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ±äÁ¿¡£


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


Ïà¹ØÎÊ´ð£º

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¿ÉÒÔµ¼³ö±í£¬Êý¾Ý¿â£¬Ôõôµ¼³öij¸ö×ֶεÄÊý¾ÝÄØ£¿²»ÖªµÀ´ó¼ÒÓÐûÓÐÕâôÊÔ¹ýµÄ£¿ÊDz»Êǵ¼³öÊý¾ÝµÄ×îСµ¥Î»¾ÍÊÇ±í£¿
Óù¤¾ß¿ÉÒÔÑ¡ÔñÁе쬱ÈÈçsqlyog

лл£¬ÒѾ­½â¾ö£¬ÎÒÓõÄÊÇÃüÁºÇºÇ
......

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ºÅ