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

srcsde,sql server,vbÎÊÌâ

sdeµ¼Èëµ½SqlServerÖеÄpoints×Ö¶ÎÊÇimageÀàÐÍ£¬ÎÒÔõôÔÚvbÖлñµÃ×ø±êÊý¾Ý£¿£¿£¿

¹ØÓÚ¸ù¾ÝpointsÓÖÔõô²éѯ£¿£¿
points×Ö¶ÎÊÇimageÀàÐÍÊÇʲôÒâ˼?ÄܰÑÄãµÄÎÊÌâ˵Çå³þµãÂð

ÒýÓÃ
sdeµ¼Èëµ½SqlServerÖеÄpoints×Ö¶ÎÊÇimageÀàÐÍ£¬ÎÒÔõôÔÚvbÖлñµÃ×ø±êÊý¾Ý£¿£¿£¿

¹ØÓÚ¸ù¾ÝpointsÓÖÔõô²éѯ£¿£¿



Òâ˼ÊÇ£¬ÔÚÓÃsde°ÑshpÎļþµ¼Èëµ½sql serverÖУ¬ÔÚshpÖÐÓиöpoints×ֶΣ¬ËûµÄ×÷ÓþÍÊÇÃèÊö×ø±ê£¬»òÔòÊÇÇøÓò£¬Ïߣ¬ÃæµÄ£¡µ±µ¼Èëµ½sql serverÖУ¬»áÓÃimageÀàÐÍ×ֶδ洢¡£ÏÖÔÚÎÒÏëͨ¹ýsql²éѯµ½Õâ¸öÖµ£¬µ«ÊDz»ÖªµÀÔÚ´úÂëÖÐרÃÅÃèÊöÕâ¸öÖµ£¬Òâ˼¾ÍÊÇ£¬ÎÒ»ñȡֵ¸¶¸øÊ²Ã´ÀàÐ͵ıäÁ¿£¬»òÔò  sde×é¼þµÄij¸ö¶ÔÏ󡣡£¡££¿£¿£¿£¿

ÒýÓÃ
points×Ö¶ÎÊÇimageÀàÐÍÊÇʲôÒâ˼?ÄܰÑÄãµÄÎÊÌâ˵Çå³þµãÂð



Òâ˼ÊÇ£¬ÔÚÓÃsde°ÑshpÎļþµ¼Èëµ½sql serverÖУ¬ÔÚshpÖÐÓиöpoints×ֶΣ¬ËûµÄ×÷ÓþÍÊÇÃèÊö×ø±ê£¬»òÔòÊÇÇøÓò£¬Ïߣ¬ÃæµÄ£¡µ±µ¼Èëµ½sql serverÖУ¬»áÓÃimageÀàÐÍ×ֶδ洢¡£ÏÖÔÚÎÒÏëͨ¹ýsql²éѯµ½Õâ¸öÖµ£¬µ«ÊDz»ÖªµÀÔÚ´úÂëÖÐרÃÅÃèÊöÕâ¸öÖµ£¬Òâ˼¾ÍÊÇ£¬ÎÒ»ñȡֵ¸¶¸øÊ²Ã´ÀàÐ͵ıäÁ¿£¬»òÔò  sde×é¼þµÄij¸ö¶ÔÏ󡣡£¡££¿£¿£¿£¿

ÄãµÄpoints×Ö¶ÎÔÚSHPÖÐÊÇʲô¸ñʽµÄÄØ?Ò»°ãµ¼ÈëSDEµÄÊý¾Ý¿âÖ®ºóÖ»»á²úÉúOBJECTID»òÕßSHAPEµÈÀàÐ͵ÄINT×Ö¶Î,²»ÖªµÀÄãÊÇÔõôµ¼µÄ

µã,Ïß»òÕßÃæµÄ×ø±êÐÅÏ¢²»»á´æÔÚ±¾ÉíÕâÕűíÖеÄ,³ý·ÇÄãSHPͼ²ãÖб¾ÉíÓÐ×ø±êÐÅÏ¢µÄ×Ö¶Î


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

vbÓëxmlÎÊÌâ

vbÖÐÔõôͨ¹ýxmlÀ´½âÎöÊý¾Ý¿âÖеÄ×Ö¶ÎÖµ¡£
û°ì·¨ÓÃXML½âÎöÊý¾Ý¿âµÄ×Ö¶ÎÖµ£¬³ý·ÇÊý¾Ý¿âÖб£´æµÄÊÇXML¸ñʽµÄ×Ö·û´®Îĵµ¡£

XMLÓÃÀ´Õ¹Ê¾²ã´ÎµÄÊý¾Ý¡£
Êý¾Ý¿âÒ»°ãÊǶþάÊý¾Ý¡£

Êý¾Ý¿âÖб£´æµÄÊÇXML×Ö·û´®¸ñʽ£ ......

VBÐÞ¸Ä×¢²á±í

ÓÃVBÔõôֻÕë¶Ôwindows×Ô´øµÄÎļþµÄÓÒ¼üÌí¼Ó²Ëµ¥ È磨.txt .doc)
Õâ¸öÊÇÖ»Õë¶ÔÒÔÕâÁ½¸öΪÀ©Õ¹ÃûµÄÎļþ²Ù×÷
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\txtfile\shell\[Ëæ±ãÆðÃû]\command]
@= ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ