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

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ÓÐÊ²Ã´Çø±ð£¿

mysqlºÍmssqlÓÐÊ²Ã´Çø±ð£¿ËûÁ©ÊDz»ÊÇÒ»¸ö¶«Î÷£¿
²»ÊÇÒ»¸ö³§¼ÒµÄÊý¾Ý¿â²úÆ·¡¡

µÚ¶þ¸ö×Öĸ²»Ò»Ñù

ËûÃǶ¼ÊÇDBMS£¬Êý¾Ý¿â¹ÜÀíϵͳ£¬Ö»ÊÇÁ½¸ö²»Í¬¹«Ë¾£¨»ò×éÖ¯£©µÄ²úÆ·¡£
MSSQL¹ËÃû˼Òå¾ÍÊÇ΢Èí¹«Ë¾µÄ²úÆ·£¬È«³ ......

½«ExcelÊý¾Ýµ¼Èëµ½MSsqlºÍMysql

ExcelÖ÷ÒªÊÇÈý¸ö×Ö¶Î:firstname, familyname, age
Êý¾Ý¿âµÄ±í STU Ò²°üº¬Èý¸ö×Ö¶Î:firstname, familyname, age

ÎÒÏëÒª:ÔÚÒ»¸öaspxÒ³ÃæÖеã»÷Ò»¸ö°´Å¥"µ¼ÈëExcelÊý¾Ý",µ¯³öÑ¡ÔñÎļþµÄ¶Ô»°¿ò,È»ºó ......

mssql ÅÅÐòÎÊÌ⣿ÇóÖú


select * from todaytask where datediff("n",taskonlinetime,getdate()) <15 order by rank asc,addtasktime desc

ÕâÀï²éѯ 15·ÖÖÓÔÚÏßµÄÈÎÎñ ͨ¹ýrankºÍaddtasktimeÅÅÐò

rankÊýֵΠ......

MSSQL ²Ù×÷½á¹û¼¯

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ