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

delphiµ¼Èëexcelµ½sqlserverµÄsqlÓï¾äÎÊÌâ

'Select * into '+TempTableName+' from OpenDataSource(''Microsoft.JET.OLEDB.4.0'',''Data Source='
  +ExcelFilePath+';Mode=Read;Extended Properties=Excel 5.0;Persist Security Info=True'')...['
  +SheetName+'$]';
Èç¹ûÎÒµÄexcel±íÖеÄsheetname´øÓС°£¨£©¡±£¨±ÈÈçsheetnameÊÇ£º¼Û¸ñ£¨Ïêϸ£©£©Õâ¸öµÄ»°£¬Õâ¾äÓï¾ä¾Í»á±¨´í¡£
ÔÚÎÒ²»ÐÞ¸ÄsheetnameµÄǰÌáÏ£¬ÎÒÔõôÈÃÕâ¸ösqlÓï¾ä²»±¨´í£¬ÄÜÕýÈ·Ö´ÐÐÄØ£¿



'SELECT * into '+TempTableName+' from openrowset(''MICROSOFT.JET.OLEDB.4.0'',
''Excel 5.0;HDR=YES;DATABASE='+ExcelFilePath+''',''select * from ['+SheetName+'$]'')';

ѧϰ

ÒýÓÃ
'Select * into '+TempTableName+' from OpenDataSource(''Microsoft.JET.OLEDB.4.0'',''Data Source='
  +ExcelFilePath+';Mode=Read;Extended Properties=Excel 5.0;Persist Security Info=True'')...['
  +SheetName+'$]';
Èç¹ûÎÒµÄexcel±íÖеÄsheetname´øÓС°£¨£©¡±£¨±ÈÈçsheetnameÊÇ£º¼Û¸ñ£¨Ïêϸ£©£©Õâ¸öµÄ»°£¬Õâ¾äÓï¾ä¾Í»á±¨´í¡£
ÔÚÎÒ²»ÐÞ¸ÄsheetnameµÄǰÌáÏ£¬ÎÒÔõôÈÃÕâ¸ösqlÓï¾ä²»±¨´í£¬ÄÜÕýÈ·Ö´ÐÐÄØ£¿


´ó¸ç£¬ÎÒµÄÎÊÌâ²»ÊDz»»áµ¼È룬Êǵ¼ÈëµÄʱºòsheetnameÈç¹ûÓС°()¡±Õâ¸ö×Ö·ûµÄ»°¾Íµ¼Èëʧ°Ü¡£


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

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

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

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ