mssqlÖ´Ðд洢¹ý³Ì×ÊÔ´²»×㲿·Ö½á¹ûÒѱ»É¾³ý
ÎÊÌâÈçÉÏ£¬ÔÚÖ´Ðд洢¹ý³ÌµÄʱºòÖ´ÐÐÍêÁË£¬½á¹ûûɶÎÊÌ⣬¾ÍÊÇÌáʾÓдíҲûÓдíÎó´úÂë¾ÍÊǵ¯³ö¸ö¿ò¿ò¡°×ÊÔ´²»×㣬²¿·Ö½á¹ûÒѱ»É¾³ý¡±£¬´ó¼ÒÓоÑéµÄ¸ø¿´¿´¿ÉÄÜÊÇʲôÔÒò£¬Ð»Ð»ÁË
×ÊÔ´²»×ã ÏÔʾ²»ÏÂÁË Ã»É¶ÎÊÌâ°É
ÎÒÔÚ´æ´¢¹ý³ÌΪÁ˵÷ÊÔ¼ÓÁ˲»ÉÙprint ÄãÊÇ˵Õâ¸öÏÔʾ²»ÏÂÂð
ͬÒâ¡£
°ÑÄãµÄprint¸ø×¢Ê͵ô
ºÃÎÒÊÔÊÔ
°Ñprint×¢Ê͵ô,²¢ÇÒset nocount on
ÕæµÄºÃÁË Ð»Ð»·Ç³£¸Ðл´ó¼Ò
ϵͳ×ÊÔ´²»×ãÔÒò°É~
Ïà¹ØÎÊ´ð£º
ÎÒ×°µÄÊÇWin2003ϵͳ£¬·Ö±ð°²×°ÁËsql server2000ºÍsql server2005£¬ÏÖÔÚ³öÏÖÁËһЩÎÊÌ⣬¾ÍÊÇÔÚ¾ÖÓòÍøÄÚÆäËüµÄµçÄÔÓÃSQL 2000ÎÞ·¨·ÃÎʵ½ÎÒµÄÊý¾Ý¿â~~Ìáʾ´íÎóΪ£ºSQL Server²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø£¬Ö®Ç°Ö»ÓÐSQL 2000µÄÊ ......
ÉÌÆ·±í
ProductManager_Name ProductManager_Type_Id
-------------------------------------------------------------
Öйú¾¼ÃÈȵãÑо¿ ......
ÎÒµÄÓï¾äÈçÏ£º
$myServer = "124.172.125.197"; //Ö÷»ú
$myUser = "jmkjxy"; //Óû§Ãû
$myPass = "jmkjxy023"; //ÃÜÂë
$myDB = "jmkjxy"; //MSSQL¿âÃû ......
MSSQLij×Ö¶ÎijЩÄÚÈÝÌæ»»
ÀýÈç±í S_ORDER , ×Ö¶Î NAME
AAA¾×asdfasd
  ......
ÊÇ·ñÄÜÔÚijЩINSERT,UPDATE,DELETEµÄʱºò,²»Ð´ÊÂÎñÈÕÖ¾?ÒòΪÎÒijЩ²Ù×÷²»ÐèҪдÈÕÖ¾(±ÈÈçÁÙʱ¼ÆËãÓõıí,ijЩÁÙʱͼ¿â)
ÎÒÏÖÔÚÖªµÀ:
ÔÚ¼òµ¥ÈÕ־ģʽÏÂ,SELECT INTO ²»²úÉúÈÕÖ¾,
Ìý˵ORACLE¿ÉÒÔʵÏÖijЩ ......