ÖÕÓڸ㶨PHPÁ¬½ÓSQLServer2005.
ΪÁËphpÁ¬½Ósql2005 ,ÎÒÔÚÍøÂçÉÏÕÒÁËÒ»´ó¶Ñ×ÊÁÏÔÚÎÒµÄcsdn²©¿ÍÖÐ.ÍíÉÏ3:05·ÖʱºòÖÕÓڸ㶨ÁË phpÁ¬½Ósql2005µÄÎÊÌâ,ÏÖÔÚÕûºÏ,ͬʱ°ÑFAQÕûºÏÉÏ. ÎÒÇ°ÃæдµÄ½Ì³Ì: Á¬½ÓÇ°ÅäÖÃϵͳ: 1.¼ì²éÎļþ php5.2.5\ntwdblib.dll ĬÈÏÏÂÃæÓÐÒ»¸ö,²»ÄÜÁ¬½ÓÔÙÌæ»». ÏÂÔØÕýÈ·°æ±¾µÄ ntwdblib.dll (2000.80.194.0)£¬µØÖ·£º http://webzila.com/dll/1/ntwdblib.zip 2.ÅäÖÃphp a¡¢´ò¿ªphp.in½«extension=php_mssql.dllµÄ×¢ÊÍ·ûºÅÈ¥µô¡£ b¡¢´ò¿ªphp.in½«mssql.secure_connection = Off¸ÄΪon¡£ c¡¢½«php_mssql.dll¿½±´µ½php.inÖÐextension_dir Ö¸¶¨µÄĿ¼»òÕßϵͳsystem32Ŀ¼Ï¡£(php_mssql.dllÔÚphpµÄѹËõ°²×°°üÖÐÓÐ)¡£ ÒÔÉϲ½ÖèÍê³ÉºóÐèÒªÖØÆôapache¡£ ×¢Ò⣺ʵ¼ÊʹÓÃÖз¢ÏÖ Èç¹ûͨ¹ýphpѹËõÎļþÊÖ¹¤°²×°phpµ½iisÏ£¬±ØÐëÖØÆô»úÆ÷¶ø²»½ö½öÊÇiis¡£ 3.ÅäÖÃsqlserver
a. ÔËÐÐ SQL Server ÅäÖùÜÀíÆ÷£ºSQL Server Configuration Manager£¬´ò¿ªÐÒé Protocols
b. ÔÊÐíÃüÃû¹ÜµÀ "named pipes" ºÍ "tcp/ip"
c. ÓÒ¼üµã»÷ "tcp/ip"£¬´ò¿ªÊôÐÔ Properties ±êÇ© "IP addresses"
d. ÔÚ TCP ¶¯Ì¬¶Ë¿Ú "TCP Dynamic Ports" ÌîÈë 1433
e. ÖØÆô SQL Server -----------------------------------------------------------------------------------------------
4.ʹÓÃÒÔÏ·½Ê½Á¬½ÓMS SQL Server 2005£º
´úÂëÈçÏ£º ÊäÈëhttp://127.0.0.1 ----------------------------------------------------------------------- 5.FAQ³£¼ûÎÊÌâ: 1±¨´í: Fatal error: Call to undefined function mssql_connect() ½â¾ö: ʹÓÃMSSQL_ϵÁк¯Êý
ҪʹÓÃÕâÁ½ÖÖ¶¼ÐèÒªÔÚphp.ini½øÐÐÉ趨£º
(1)ÔÊÐí DCOM£¬ÐèÒª½«php.iniÖÐµÄ ;com.allow_dcom=TRUEÇ°µÄ·ÖºÅ";"È¥µô¡£
(2)ʹÓÃMSSQLÀ©Õ¹£¬ÐèÒªphp.iniÖÐµÄ ;extension=php_mssql.dllÇ°µÄ·ÖºÅ";"È¥µô¡£(¹Ø¼ü)
(3)È·ÈÏextension_dirΪÕýȷ·¾¶,ÒÔ±¾»úΪÀý£ºextension_dir = "c:\AppServ5.2.6\php\ext"¡£
(4)Èç¹ûÈÔÈ»»úÆ÷±¨´í˵ÕÒ²»µ½c:\AppServ5.2.6\php\ext\php_mssql.dllµ«Ã÷Ã÷´æÔÚÕâ¸öÎļþ¡£
½â¾ö·½·¨£º½«php_mssql.dll,ntwdblib.dll¿½±´µ½ÏµÍ³Ä¿Â¼\system32ÏÂÖØÆô²âÊÔ¡£¡£
(×¢:ÉÏÃæÁ½¸ödllÎļþ²»ÔÚÏàͬĿ¼Ï£¬ÎÒµÄΪc:
Ïà¹ØÎĵµ£º
Ö»ÊÇsqlserver ÌṩµÄÔ¶³ÌÊý¾Ý·ÃÎʺ¯Êý; ÔÚ±¾µØsqlserver ÖÐÈ¡ÍⲿÊý¾ÝÔ´Êý¾Ýʱºò¿ÉÓÃ;
¶ÔÁ¬½Ó±¾µØ oracle ²Ù×÷Ô¶³Ì oracle ²»ÄÜʹÓÃ; ²âÊÔ: pl/sql ÖÐʹÓÃ:
select * from openrowset(................); ÎÞЧ!!!!!!!!!!!!!!
ÔÚoracle ÖÐÐèÒª·ÃÎÊÔ¶³ÌÊý¾Ý,ÐèÒª½¨Á¢Ò»Á¬½ÓÔ¶³Ìoracle µÄ dblink ;
ÔÙÓÃÈçÏ·½ ......
· ±¾ÎÄÌÖÂÛÁËÈçºÎͨ¹ýTransact-SQLÒÔ¼°ÏµÍ³º¯ÊýOPENDATASOURCEºÍOPENROWSETÔÚͬ¹¹ºÍÒì¹¹Êý¾Ý¿âÖ®¼ä½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬²¢¸ø³öÁËÏêϸµÄÀý×ÓÒÔ¹©²Î¿¼¡£
1. ÔÚSQL ServerÊý¾Ý¿âÖ®¼ä½øÐÐÊý¾Ýµ¼Èëµ¼³ö
(1).ʹÓÃSELECT INTOµ¼³öÊý¾Ý
  ......
1.Èç¹ûÏÈprepare ºóÌí¼Ó²ÎÊý£¬ÕâÑùÒ»²¿·ÖÊý¾ÝÀàÐÍ¿ÉÒÔ²»ÓÃÉèÖÃÆäsize´óС£¬ÀýÈçchar
2.Èç¹ûÏÈÌí¼Ó²ÎÊýÔÙprepare£¬¾Í±ØÐëÉèÖòÎÊýµÄÀàÐÍ£¬´óС£¬¾«¶È²ÅÄÜͨ¹ý£¬±ÈÈçchar,varchar,decimalÀàÐÍ£¬¶øint,floatÓй̶¨×Ö½ÚÀàÐ͵ÄÊý¾ÝÀàÐÍÔò¿É²»ÓÃÉèÖôóС¡£
3.¹ØÓÚSqlServerµÄtimestampÀàÐÍ£º¸ÃÀàÐÍΪSqlServerµÄʱ¼ä´ÁÀàÐÍ£¬´´½ ......
Ò» ÔÚOracleÖÐÁ¬½ÓÊý¾Ý¿â
public class Test1 {
public static void main(String[] args) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(
&nbs ......
sqlserver×Ö·û´®²ð·Ö(split)·½·¨»ã×Ü
--·½·¨0£º¶¯Ì¬SQL·¨
declare @s varchar(100),@sql varchar(1000)
set @s='1,2,3,4,5,6,7,8,9,10'
set @sql='select col='''+ replace(@s,',',''' union all select ''')+''''
PRINT @sql
exec (@sql)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ ......