srcsde,sql server,vbÎÊÌâ
sdeµ¼Èëµ½SqlServerÖеÄpoints×Ö¶ÎÊÇimageÀàÐÍ£¬ÎÒÔõôÔÚvbÖлñµÃ×ø±êÊý¾Ý£¿£¿£¿
¹ØÓÚ¸ù¾ÝpointsÓÖÔõô²éѯ£¿£¿
points×Ö¶ÎÊÇimageÀàÐÍÊÇʲôÒâ˼?ÄܰÑÄãµÄÎÊÌâ˵Çå³þµãÂð
Òâ˼ÊÇ£¬ÔÚÓÃsde°ÑshpÎļþµ¼Èëµ½sql serverÖУ¬ÔÚshpÖÐÓиöpoints×ֶΣ¬ËûµÄ×÷ÓþÍÊÇÃèÊö×ø±ê£¬»òÔòÊÇÇøÓò£¬Ïߣ¬ÃæµÄ£¡µ±µ¼Èëµ½sql serverÖУ¬»áÓÃimageÀàÐÍ×ֶδ洢¡£ÏÖÔÚÎÒÏëͨ¹ýsql²éѯµ½Õâ¸öÖµ£¬µ«ÊDz»ÖªµÀÔÚ´úÂëÖÐרÃÅÃèÊöÕâ¸öÖµ£¬Òâ˼¾ÍÊÇ£¬ÎÒ»ñȡֵ¸¶¸øÊ²Ã´ÀàÐ͵ıäÁ¿£¬»òÔò sde×é¼þµÄij¸ö¶ÔÏ󡣡£¡££¿£¿£¿£¿
Òâ˼ÊÇ£¬ÔÚÓÃsde°ÑshpÎļþµ¼Èëµ½sql serverÖУ¬ÔÚshpÖÐÓиöpoints×ֶΣ¬ËûµÄ×÷ÓþÍÊÇÃèÊö×ø±ê£¬»òÔòÊÇÇøÓò£¬Ïߣ¬ÃæµÄ£¡µ±µ¼Èëµ½sql serverÖУ¬»áÓÃimageÀàÐÍ×ֶδ洢¡£ÏÖÔÚÎÒÏëͨ¹ýsql²éѯµ½Õâ¸öÖµ£¬µ«ÊDz»ÖªµÀÔÚ´úÂëÖÐרÃÅÃèÊöÕâ¸öÖµ£¬Òâ˼¾ÍÊÇ£¬ÎÒ»ñȡֵ¸¶¸øÊ²Ã´ÀàÐ͵ıäÁ¿£¬»òÔò sde×é¼þµÄij¸ö¶ÔÏ󡣡£¡££¿£¿£¿£¿
ÄãµÄpoints×Ö¶ÎÔÚSHPÖÐÊÇʲô¸ñʽµÄÄØ?Ò»°ãµ¼ÈëSDEµÄÊý¾Ý¿âÖ®ºóÖ»»á²úÉúOBJECTID»òÕßSHAPEµÈÀàÐ͵ÄINT×Ö¶Î,²»ÖªµÀÄãÊÇÔõôµ¼µÄ
µã,Ïß»òÕßÃæµÄ×ø±êÐÅÏ¢²»»á´æÔÚ±¾ÉíÕâÕűíÖеÄ,³ý·ÇÄãSHPͼ²ãÖб¾ÉíÓÐ×ø±êÐÅÏ¢µÄ×Ö¶Î
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
101 50 08£º00 08£º30 30 40 50
101 50 09£º00 ......
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À´½âÎöÊý¾Ý¿âÖеÄ×Ö¶ÎÖµ¡£
û°ì·¨ÓÃXML½âÎöÊý¾Ý¿âµÄ×Ö¶ÎÖµ£¬³ý·ÇÊý¾Ý¿âÖб£´æµÄÊÇXML¸ñʽµÄ×Ö·û´®Îĵµ¡£
XMLÓÃÀ´Õ¹Ê¾²ã´ÎµÄÊý¾Ý¡£
Êý¾Ý¿âÒ»°ãÊǶþάÊý¾Ý¡£
Êý¾Ý¿âÖб£´æµÄÊÇXML×Ö·û´®¸ñʽ£ ......
ÓÃVBÔõôֻÕë¶Ôwindows×Ô´øµÄÎļþµÄÓÒ¼üÌí¼Ó²Ëµ¥ È磨.txt .doc)
Õâ¸öÊÇÖ»Õë¶ÔÒÔÕâÁ½¸öΪÀ©Õ¹ÃûµÄÎļþ²Ù×÷
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\txtfile\shell\[Ëæ±ãÆðÃû]\command]
@= ......