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

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


Ïà¹ØÎÊ´ð£º

phpÁ¬½ÓMSSQL Á¬²»ÉÏ - PHP / »ù´¡±à³Ì

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 MSSQL - Java / Java SE

ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates
Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......

ÇóÒ»¸ömssqlµÄsqlÓï¾ä - MS-SQL Server / »ù´¡Àà

ÅжϱíÖÐÊÇ·ñÓдóÓÚ10ÌõÒÔÉϵÄÊý¾Ý£¬
Èç¹û´æÔÚÔò°´×îºÃ¼ÈëµÄʱ¼ä£¬É¾³ýµô¶àÓàµÄÊý¾Ý¡£¡£
±£³ÖÊý¾Ý±íÖÐÖ»ÓÐ10Ìõ×îеÄÊý¾Ý¡£¡£
лл¡£
select ID,count(1) from TB group by ID having count(1)>10


SQL ......

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

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

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

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

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

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

Ö§³ÖµÄ
»¹ÊǺ£ÔôÃÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ