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

¸´ÖÆmssqlÐеÄÎÊÌâ - Web ¿ª·¢ / ASP

ÈçÌâ
ÎÒʹÓÃ

VBScript code:
conn.execute("SET IDENTITY_INSERT [abc] On" & vbcrlf & "insert into [abc] (id,name,qq,msn) select (select top 1 id from [abc] order by id desc)+1,name,qq,msn) from [abc] where id="&sid&" & vbcrlf & "SET IDENTITY_Insert [abc] OFF")


ÕâÑù¿ÉÒÔ¸´ÖÆÐµÄÒ»ÐУ¬µ«ÊÇÈç¹ûÓкܶàÓû§Í¬Ê±Ê¹Óã¬Èç¹û²¢·¢µÄ»°£¬ÕâÀïÃæµÄselect top 1¿Ï¶¨¾Í²»¶ÔÁË£¿

Ó¦¸ÃÔõô½â¾öÄØ£¿ÓÐÁíÍâ±È½Ï·½±ãµÄ¸´ÖÆmssqlÐеķ½·¨Âð£¿

ÏÈselect³öÀ´Ò»¸ö¼Ç¼¼¯£¬ÔÙconn.execute insert intoдÈëÊý¾Ý¿â£¿


ÄãµÄÒâ˼ÊÇ£¬ÎÒÓÃIDENTITY_INSERT OnÕâÑùµÄÓï¾äû¹ØÏµÂð£¿

ÒýÓÃ
Ó¦¸Ã²»»á£¬ÓÐÊÂÎñºÍËø
Óï¾äÌ«¶àд´æ´¢¹ý³Ì£¬ÕâÑù³ÌÐòά»¤·½±ã



Ïà¹ØÎÊ´ð£º

php´Ómssql¶ÁblobÀàÐÍÏÔʾͼÏñ - PHP / »ù´¡±à³Ì

ÒòϵͳÐèÇ󣬽«Í¼Ïñ·ÅÈëmssqlÖУ¬×Ö¶ÎÀàÐÍΪblob£¬Í¼ÏñΪjpgÀàÐÍ£¬ÈçÏ´úÂëÖ´ÐÐʱ²¢²»ÄÜÕýÈ·Êä³öͼÏñ£¬Âé·³¸÷λ°ï濴һϣ¬·Ç³£¸Ðл!!
<?php
  include_once("db.class.php");
// retr ......

mssql ÅúÁ¿²åÈëÊý¾Ý - MS-SQL Server / ÒÉÄÑÎÊÌâ

СµÜÒªÓÃc# ×ö¸öС¹¤¾ß£¬¾ÍÊǸøÊý¾Ý¿âÖеıí¸ñÅúÁ¿²åÈëÊý¾Ý£¬ÎÒÏ뾡Á¿·ûºÏ±í½á¹¹¹ØÏµµÄÊý¾Ý²åÈë½üÀ´£¬ ±ÈÈçÒª¿¼ÂÇÖ÷Í⽡µÈÐÅÏ¢£¬±È·½Ëµ ÓÐ a b c dÈý¸ö±í£¬¶øÎÒÈçºÎÔÚÊý¾Ý¿âÖÐÈ·ÈÏÖ÷¼üºÍÍâ¼ü£¬µ½µ×¸ÃÈçºÎÈ·ÈϲåÈë˳Р......

php5.3Ö§³ÖmssqlÂð - PHP / »ù´¡±à³Ì

°²×°²»ÁËmssql£¬ÈçºÎÅäÖÃÄØ
ûÈË

extension=php_mssql.dll
°²×°ÕýÈ·Á˺󣬸ÄPHP¡£INIÔÙÖØÆð¡£

php startup:unable to load dynamic library 'ext\php_mssql.dll - ÕÒ²»µ½Öƶ¨µÄÄ£¿é

Ö§³ÖµÄ
»¹ÊǺ£ÔôÃÔ ......

MSSQL ÈçºÎÍêÕûµÄ¸´ÖÆÒ»±í - MS-SQL Server / »ù´¡Àà

ÈçÌâ,Ö»Òª±í½á¹¹.²»ÐèÒªÊý¾ÝµÄ.±í½á¹¹¸´Öƺܺø´ÖÆ.µ«ÊǸú±íÓйصĴ¥·¢Æ÷,Ë÷ÒýµÈ,»¹ÓÐͳ¼ÆÐÅÏ¢Õâ¸öÊý¾ÝÄܹ»Ò»Æð¸´ÖÆ×ßÂð.¾ÍÊÇÁ½ÕűíÊÇһģһÑùµÄ.
select * into b from a

ÒýÓÃ
select * into b from a
ûÓÃ,Õ ......

MSSQL ÐÐÊýͳ¼ÆµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÓÐÁ½¸ö±í£¬ÊýÁ¿¼¶ÔÚ3000w×óÓÒ£¬
Ïë²é¿´¾ßÌåµÄÊýÁ¿£¬ÓÃselect Count(*) ËÙ¶ÈÌ«Âý£¬
֮ǰ¿´µ½ËµÔÚsysindexesÖÐÓÐrows ÁУ¬ µ«ÊÇÎÒ·¢ÏÖ£¬ÕâÁ½¸öµÄÖµ²»Ò»Ñù£¬Ôõô»ØÊ°¡£¿
лл
ÓÐÈËÄܻشðÒ»ÏÂÂð? ²»ÊǺÜÃ÷°×°¡

Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ