MSSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞÖÆ
MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞÖÆÊÇ:GRANT ALL PRIVILEGES ON *.* TO username'@'IPµØÖ· IDENTIFIED BY 'ÃÜÂë ' WITH GRANT OPTION ÓÐËÖªµÀÔÚMSSQLÖÐÔõôÉèÖÃIP·ÃÎÊÏÞÖÆ
ÒýÓà MYSQLÖÐÔ¶³ÌIP·ÃÎÊÏÞÖÆÊÇ:GRANT ALL PRIVILEGES ON *.* TO username'@'IPµØÖ· IDENTIFIED BY 'ÃÜÂë ' WITH GRANT OPTION ÓÐËÖªµÀÔÚMSSQLÖÐÔõôÉèÖÃIP·ÃÎÊÏÞÖÆ ·À»ðÇ¿ÉèÖà Õâ¸öÃ²ËÆÃ»ÓУ¬¿ÉÒÔͨ¹ýwindows²Ù×÷ϵͳµÄ°²È«²ßÂÔÀ´×ö SQL ÖÐÊÇûÓÐÕâ¸ö¹¦ÄÜµÄ ÎÒÔÚÍøÉϲé¹ýÁ˴󲿷ֶ¼ÊÇ˵ҪÔÚ·À»ðǽÀïÃæÉèÖã¬ÄѵÀMSSQL¾ÍûÓÐÉèÖÃIPÏÞÖÆµÄÂð ÅäÖà IPSEC¡£ ÁùÂ¥ ÆóÒµ¹ÜÀíÆ÷-> ÓÒ¼üSQlserver×é-> н¨sqlserver×¢²á-> ÏÂÒ»²½-> дÈëÔ¶³ÌIP-> ÏÂÒ»²½-> Ñ¡SqlserverµÇ½-> ÏÂÒ»²½-> дÈëµÇ½ÃûÓëÃÜÂë(sa,password)-> ÏÂÒ»²½-> ÏÂÒ»²½-> Íê³É Õâ¸öÒªÊÇÓôúÂëµÄ»°£¬ÒªÔõôд£¿ --´´½¨Á´½Ó·þÎñÆ÷ execsp_addlinkedserver 'ITSV ' '' 'SQLOLEDB ' 'Ô¶³Ì·þÎñÆ÷Ãû»òipµØÖ· ' execsp_addlinkedsrvlogin 'ITSV ' 'false 'null 'Óû§Ãû ' 'ÃÜÂë ' --²éѯʾÀý select*fromITSV.Êý¾Ý¿âÃû.dbo.±íÃû ÍøÉÏÕҵģ¬¿´×ÖÃæµÄÒâ˼£¬´úÂëÊÇͨ¹ýÕâ¸öÀ´ÊµÏÖ£¬ÏÈÈ¥ÊÔÏÂ
Ïà¹ØÎÊ´ð£º
mysqlºÍmssqlÓÐÊ²Ã´Çø±ð£¿ËûÁ©ÊDz»ÊÇÒ»¸ö¶«Î÷£¿ ²»ÊÇÒ»¸ö³§¼ÒµÄÊý¾Ý¿â²úÆ·¡¡ µÚ¶þ¸ö×Öĸ²»Ò»Ñù ËûÃǶ¼ÊÇDBMS£¬Êý¾Ý¿â¹ÜÀíϵͳ£¬Ö»ÊÇÁ½¸ö²»Í¬¹«Ë¾£¨»ò×éÖ¯£©µÄ²úÆ·¡£ MSSQL¹ËÃû˼Òå¾ÍÊÇ΢Èí¹«Ë¾µÄ²úÆ·£¬È«³ ......
ExcelÖ÷ÒªÊÇÈý¸ö×Ö¶Î:firstname, familyname, age Êý¾Ý¿âµÄ±í STU Ò²°üº¬Èý¸ö×Ö¶Î:firstname, familyname, age ÎÒÏëÒª:ÔÚÒ»¸öaspxÒ³ÃæÖеã»÷Ò»¸ö°´Å¥"µ¼ÈëExcelÊý¾Ý",µ¯³öÑ¡ÔñÎļþµÄ¶Ô»°¿ò,È»ºó ......
select * from todaytask where datediff("n",taskonlinetime,getdate()) <15 order by rank asc,addtasktime desc ÕâÀï²éѯ 15·ÖÖÓÔÚÏßµÄÈÎÎñ ͨ¹ýrankºÍaddtasktimeÅÅÐò rankÊýֵΠ......
SQL code: For Ls_desc IN (Select Di_ename ,Di_Pcs,Di_Unitprice from T_BO_DeclareInvoice Di WHERE bs_code = as_bs_code) LOOP IF Ls_desc.Di_ename IS ......