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

ÎÊÌ⣺ͨ¹ýsql ö¾Ùsqlserver ÉϽ¨Á¢µÄÁ´½Ó·þÎñÆ÷Áбí

ÎÊÌâÊÇÕâÑùµÄ£¬
Îҵı¾µØsqlserver 2000 ·þÎñÆ÷ÉÏ£¬½¨Á¢Á˶à¸öÔ¶³ÌÁ´½Ó·þÎñÆ÷£¬
ÇëÎÊ£¬ÎÒÈçºÎͨ¹ý sqlÓï¾ä£¬»òÕ߯äËûµÄ·½·¨Ã¶¾Ù ÕâЩÁ´½Ó·þÎñÆ÷ÄØ£¿£¨Í¨¹ýÆóÒµ¹ÜÀíÆ÷ÎÒÊÇÖªµÀµÄ£¬
ÎÒÒªµÄÊÇÄÜͨ¹ý±à³Ìö¾Ùµ½µÄ·½·¨£©
û×ö¹ý£¬²»¶®



--exec sp_addlinkedserver '×¢²áÃû','','SQLOLEDB','Ô¶³ÌÊý¾Ý¿âÃû'
--exec sp_addlinkedsrvlogin '×¢²áÃû','false',null,'Óû§Ãû','ÃÜÂë'
--go

ÊDz»ÊÇÕâ¸öÒâ˼£¿


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

ÔõôÁ¬½Ó°²×°Ê±Ã»ÓÐʹÓÃĬÈÏʵÀýµÄSQL Server2000?

A»úÆ÷£¨XP£©£¨10.10.6.65£©ÍêÕûµÄ¼ÆËã»úÃûÊÇ: DZD·þÎñÆ÷

ÎÒ×°ÁËÒ»¸ö¸öÈ˰棺 SQLServer2000,´´½¨ÁËÒ»¸öʵÀýÃûΪ£ºMYINSTANCE

×°ÁË£ºdotNetFx35setup.exe

²¢´òºÃÁËSP4²¹¶¡£ºSQL2000-KB884525-SP ......

ÇóÖúÒ»¾äSQLÓï¾ä

Êý¾ÝÀàÐÍ£º
Code char(6)
CreateTime datetime
Price float

Êý¾ÝÈçÏ£º

Code      CreateTime          Price
031002 2008-10-17 15:00:15 ......

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ