mssqlÔõôµÃµ½×Ô¶¯±àºÅidÖµ£¿
Çë´ó¼Ò¸ø¸öÀý×Ó¿´¿´£¬²»ÖªµÀÈçºÎÈ¥´¦Àí£¬ºÍmysql²»Ò»ÑùûÓÐרÃŵĺ¯Êý
SQL code: id INT AUTO_INCREMENT ? ÔÚ×öÒ»¸öÌí¼Ó¼Ç¼£¬½á¹û×Ô¶¯±àºÅµÄidÎÞ·¨´¦Àí£¬Â¥ÉϵÄÄÜÔÙÏêϸµãÂ𣿠ÎÞ·¨´¦ÀíÊÇʲôÒâ˼£¿²»»áÌí¼Ó±àºÅ£¿ÌùµãÊý¾Ý¿´¿´ ²»ÖªµÀ´úÂëÔõôд£¬ÓÖ²»ÄÜÓÃÀàËÆmysql_insert_idº¯ÊýÒýÓà ²»ÖªµÀ´úÂëÔõôд£¬ÓÖ²»ÄÜÓÃÀàËÆmysql_insert_idº¯Êý ÓÃÕâ¸ö·½·¨²»ÐÐÂ𣿠ÊÇ×ö²åÈë²Ù×÷Âð PHP code: insert into ºóÓà SELECT SCOPE_IDENTITY() »ò SELECT @@IDENTITY »òÕßÈÎÒâʱºòÓà SELECT IDENT_CURRENT('ij¸ö±íÃû³Æ') SQL code: »òÕßÔÙ±¿Ò»µãµÄ°ì·¨£º select max(id) from mytable ?lzÊÇʲôÒâ˼?Êý¾Ý¿âÀï±¾ÉíÓÐÒ»¸ö×ÔÔöµÄ×Ö¶Î,ÒªÔõôµÃµ½ËüµÄÖµ ? SQL code: create table t( id integer identity(1,1), //´Ó1¿ªÊ¼£¬Ã¿´Î²åÈëÔö¼Ó1,²åÈëµÄʱºòÒªÖ¸¶¨ÁÐÃû£¬ÕâÁв»Òª²åÈ룬×Ô¶¯µÄ . . . ) columnname int identity(1,1) ÊÔÒ»ÊÔ°É mysql_insert_id (PHP 3, PHP 4 , PHP 5
Ïà¹ØÎÊ´ð£º
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44 Í ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£ Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬ exec sp_helpsor ......
ÅжϱíÖÐÊÇ·ñÓдóÓÚ10ÌõÒÔÉϵÄÊý¾Ý£¬ Èç¹û´æÔÚÔò°´×îºÃ¼ÈëµÄʱ¼ä£¬É¾³ýµô¶àÓàµÄÊý¾Ý¡£¡£ ±£³ÖÊý¾Ý±íÖÐÖ»ÓÐ10Ìõ×îеÄÊý¾Ý¡£¡£ лл¡£ select ID,count(1) from TB group by ID having count(1)>10 SQL ......
ÒòϵͳÐèÇ󣬽«Í¼Ïñ·ÅÈëmssqlÖУ¬×Ö¶ÎÀàÐÍΪblob£¬Í¼ÏñΪjpgÀàÐÍ£¬ÈçÏ´úÂëÖ´ÐÐʱ²¢²»ÄÜÕýÈ·Êä³öͼÏñ£¬Âé·³¸÷λ°ï濴һϣ¬·Ç³£¸Ðл!! <?php include_once("db.class.php"); // retr ......
°²×°²»ÁËmssql£¬ÈçºÎÅäÖÃÄØ ûÈË extension=php_mssql.dll °²×°ÕýÈ·Á˺󣬸ÄPHP¡£INIÔÙÖØÆð¡£ php startup:unable to load dynamic library 'ext\php_mssql.dll - ÕÒ²»µ½Öƶ¨µÄÄ£¿é Ö§³ÖµÄ »¹ÊǺ£ÔôÃÔ ......