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

mssqlÖ´Ðд洢¹ý³Ì×ÊÔ´²»×㲿·Ö½á¹ûÒѱ»É¾³ý

ÎÊÌâÈçÉÏ£¬ÔÚÖ´Ðд洢¹ý³ÌµÄʱºòÖ´ÐÐÍêÁË£¬½á¹ûûɶÎÊÌ⣬¾ÍÊÇÌáʾÓдíҲûÓдíÎó´úÂë¾ÍÊǵ¯³ö¸ö¿ò¿ò¡°×ÊÔ´²»×㣬²¿·Ö½á¹ûÒѱ»É¾³ý¡±£¬´ó¼ÒÓо­ÑéµÄ¸ø¿´¿´¿ÉÄÜÊÇʲôԭÒò£¬Ð»Ð»ÁË
×ÊÔ´²»×ã ÏÔʾ²»ÏÂÁË Ã»É¶ÎÊÌâ°É

ÒýÓÃ
×ÊÔ´²»×ã ÏÔʾ²»ÏÂÁË Ã»É¶ÎÊÌâ°É

ÎÒÔÚ´æ´¢¹ý³ÌΪÁ˵÷ÊÔ¼ÓÁ˲»ÉÙprint  ÄãÊÇ˵Õâ¸öÏÔʾ²»ÏÂÂð

ÒýÓÃ
ÒýÓà 1 Â¥ bancxc µÄ»Ø¸´:
×ÊÔ´²»×ã ÏÔʾ²»ÏÂÁË Ã»É¶ÎÊÌâ°É

ÎÒÔÚ´æ´¢¹ý³ÌΪÁ˵÷ÊÔ¼ÓÁ˲»ÉÙprint  ÄãÊÇ˵Õâ¸öÏÔʾ²»ÏÂÂð

ͬÒâ¡£

°ÑÄãµÄprint¸ø×¢Ê͵ô

ºÃÎÒÊÔÊÔ

°Ñprint×¢Ê͵ô,²¢ÇÒset nocount on

ÕæµÄºÃÁË  лл·Ç³£¸Ðл´ó¼Ò

ϵͳ×ÊÔ´²»×ãÔ­Òò°É~


Ïà¹ØÎÊ´ð£º

MSSQL Server 2000ÓëMSSQL Server2005

ÎÒ×°µÄÊÇWin2003ϵͳ£¬·Ö±ð°²×°ÁËsql server2000ºÍsql server2005£¬ÏÖÔÚ³öÏÖÁËһЩÎÊÌ⣬¾ÍÊÇÔÚ¾ÖÓòÍøÄÚÆäËüµÄµçÄÔÓÃSQL 2000ÎÞ·¨·ÃÎʵ½ÎÒµÄÊý¾Ý¿â~~Ìáʾ´íÎóΪ£ºSQL Server²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø£¬Ö®Ç°Ö»ÓÐSQL 2000µÄÊ ......

mssql ¸ß¼¶²éѯ

ÉÌÆ·±í
ProductManager_Name                  ProductManager_Type_Id
-------------------------------------------------------------
Öйú¾­¼ÃÈȵãÑо¿ ......

ΪʲôPHPÁ¬½ÓmssqlÒ»µã·´Ó³¶¼Ã»ÓУ¬³õѧ£¬ÔÚÏßµÈ

ÎÒµÄÓï¾äÈçÏ£º
$myServer = "124.172.125.197"; //Ö÷»ú
$myUser = "jmkjxy"; //Óû§Ãû
$myPass = "jmkjxy023"; //ÃÜÂë
$myDB = "jmkjxy";  //MSSQL¿âÃû ......

MSSQLij×Ö¶ÎijЩÄÚÈÝÌæ»»

MSSQLij×Ö¶ÎijЩÄÚÈÝÌæ»»

ÀýÈç±í  S_ORDER  ,  ×ֶΠ NAME
                          AAA¾×asdfasd
  ......

MSSQLÀïûÓÐÎÞÈÕÖ¾INSERT,UPDATE,DELETE

ÊÇ·ñÄÜÔÚijЩINSERT,UPDATE,DELETEµÄʱºò,²»Ð´ÊÂÎñÈÕÖ¾?ÒòΪÎÒijЩ²Ù×÷²»ÐèҪдÈÕÖ¾(±ÈÈçÁÙʱ¼ÆËãÓõıí,ijЩÁÙʱͼ¿â)

ÎÒÏÖÔÚÖªµÀ:
ÔÚ¼òµ¥ÈÕ־ģʽÏÂ,SELECT INTO ²»²úÉúÈÕÖ¾,
Ìý˵ORACLE¿ÉÒÔʵÏÖijЩ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ