½«ExcelÖеÄÊý¾Ýµ¼Èëµ½SQL Server 2000Êý¾Ý¿âÖÐ
½«ExcelÖеÄÊý¾Ýµ¼Èëµ½SQL Server 2000Êý¾Ý¿âÖÐ
1¡¢´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬´ò¿ªÒªµ¼ÈëÊý¾ÝµÄÊý¾Ý¿â£¬ÔÚ±íÉϰ´ÓÒ¼ü£¬ËùÓÐÈÎÎñ-->µ¼ÈëÊý¾Ý£¬µ¯³öDTSµ¼Èë/µ¼³öÏòµ¼£¬°´ ÏÂÒ»²½ £¬
2¡¢Ñ¡ÔñÊý¾ÝÔ´ Microsoft Excel 97-2000£¬ÎļþÃû Ñ¡ÔñÒªµ¼ÈëµÄxlsÎļþ£¬°´ ÏÂÒ»²½ £¬
3¡¢Ñ¡ÔñÄ¿µÄ ÓÃÓÚSQL Server µÄMicrosoft OLE DBÌṩ³ÌÐò£¬·þÎñÆ÷Ñ¡Ôñ±¾µØ(Èç¹ûÊDZ¾µØÊý¾Ý¿âµÄ»°£¬Èç VVV)£¬Ê¹ÓÃSQL ServerÉí·ÝÑéÖ¤£¬Óû§Ãûsa£¬ÃÜÂëΪ¿Õ£¬Êý¾Ý¿âÑ¡ÔñÒªµ¼ÈëÊý¾ÝµÄÊý¾Ý¿â£¨Èç client£©£¬°´ ÏÂÒ»²½ £¬
4¡¢Ñ¡Ôñ ÓÃÒ»Ìõ²éѯָ¶¨Òª´«ÊäµÄÊý¾Ý£¬°´ ÏÂÒ»²½ £¬
5¡¢°´ ²éѯÉú³ÉÆ÷£¬ÔÚÔ´±íÁбíÖУ¬ÓÐÒªµ¼ÈëµÄxlsÎļþµÄÁУ¬½«¸÷ÁмÓÈëµ½ÓÒ±ßµÄ Ñ¡ÖеÄÁÐ ÁбíÖУ¬ÕâÒ»²½Ò»¶¨Òª×¢Ò⣬¼ÓÈëÁеÄ˳ÐòÒ»¶¨ÒªÓëÊý¾Ý¿âÖÐ×ֶζ¨ÒåµÄ˳ÐòÏàͬ£¬·ñÔò½«»á³ö´í£¬°´ ÏÂÒ»²½ £¬
6¡¢Ñ¡ÔñÒª¶ÔÊý¾Ý½øÐÐÅÅÁеÄ˳Ðò£¬ÔÚÕâÒ»²½ÖÐÑ¡ÔñµÄÁоÍÊÇÔÚ²éѯÓï¾äÖÐ order by ºóÃæËù¸úµÄÁУ¬°´ ÏÂÒ»²½ £¬
7¡¢Èç¹ûҪȫ²¿µ¼È룬ÔòÑ¡Ôñ È«²¿ÐУ¬°´ ÏÂÒ»²½£¬
8¡¢Ôò»á¿´µ½¸ù¾ÝÇ°ÃæµÄ²Ù×÷Éú³ÉµÄ²éѯÓï¾ä£¬È·ÈÏÎÞÎóºó£¬°´ ÏÂÒ»²½£¬
9¡¢»á¿´µ½ ±í/¹¤×÷±í/ExcelÃüÃûÇøÓò ÁÐ±í£¬ÔÚ Ä¿µÄ ÁУ¬Ñ¡ÔñÒªµ¼ÈëÊý¾ÝµÄÄǸö±í£¬°´ ÏÂÒ»²½£¬
10¡¢Ñ¡Ôñ Á¢¼´ÔËÐУ¬°´ ÏÂÒ»²½£¬
11¡¢»á¿´µ½Õû¸ö²Ù×÷µÄÕªÒª£¬°´ Íê³É ¼´¿É¡£
Ïà¹ØÎĵµ£º
1.×Ö·û´®º¯Êý
³¤¶ÈÓë·ÖÎöÓÃ
datalength(Char_expr) ·µ»Ø×Ö·û´®°üº¬×Ö·ûÊý,µ«²»°üº¬ºóÃæµÄ¿Õ¸ñ
substring(expression,start,length) ²»¶à˵ÁË,È¡×Ó´®
right(char_expr,int_expr) ·µ»Ø×Ö·û´®ÓÒ±ßint_expr¸ö×Ö·û
×Ö·û²Ù×÷Àà
upper(char_expr) תΪ´óд
lower(char_expr) תΪСд
space(int_expr) Éú³Éint_expr¸ö¿Õ¸ñ ......
---·µ»Ø±í´ïʽÖÐÖ¸¶¨×Ö·ûµÄ¿ªÊ¼Î»ÖÃ
select charindex('c','abcdefg',1)
---Á½¸ö×Ö·ûµÄÖµÖ®²î
select difference('bet','bit')
---×Ö·û×î×ó²àÖ¸¶¨ÊýÄ¿
select left('abcdef',3)
---·µ»Ø×Ö·ûÊý
select len('abcdefg')
--ת»»ÎªÐ¡×Ö·û
select lower('ABCDEFG')
--È¥×ó¿Õ¸ñºó
select ltrim(' &nbs ......
MS SQL Server 2008 ÔÚ½¨Íê±íºó£¬Èç¹ûÒª²åÈëÈÎÒâÁУ¬ÔòÌáʾ£º
µ±Óû§ÔÚÔÚSQL Server 2008ÆóÒµ¹ÜÀíÆ÷Öиü¸Ä±í½á¹¹Ê±£¬±ØÐëÒªÏÈɾ³ýÔÀ´µÄ±í£¬È»ºóÖØÐ´´½¨ÐÂ±í£¬²ÅÄÜÍê³É±íµÄ¸ü¸Ä£¬Èç¹ûÇ¿Ðиü¸Ä»á³öÏÖÒÔÏÂÌáʾ£º²»ÔÊÐí±£´æ¸ü¸Ä¡£ÄúËù×öµÄ¸ü¸ÄÒªÇóɾ³ý²¢ÖØÐ´´½¨ÒÔÏÂ±í¡£Äú¶ÔÎÞ·¨ÖØÐ´´½¨µÄ±ê½øÐÐÁ˸ü¸Ä»òÕ߯ôÓÃÁË“× ......
*
* ¹¦ÄÜ˵Ã÷:±¸·ÝºÍ»Ö¸´SQL ServerÊý¾Ý¿â
* ×÷Õß: Áõ¹¦Ñ«;
* °æ±¾:V0.1(C#2.0);ʱ¼ä:2007-1-1
* µ±Ê¹ÓÃSQL Serverʱ,ÇëÒýÓà COM×é¼þÖеÄ,SQLDMO.dll×é¼þ
* µ±Ê¹ÓÃAccessÖÐ,Çëä¯ÀÀÌí¼ÓÒýÓÃÒÔÏÂÁ½¸ödll
* ÒýÓÃC:/Progra ......
Óï·¨£º
isnull(check_expression,replacement_expression)
²ÎÊýcheck_expressionÓëreplacement_expressionÀàÐÍÐèÏàͬ
·µ»ØÖµ£º
Èôcheck_expressionΪnull£¬Ôò·µ»Øreplacement_expression
Èôcheck_expression²»Îªnull£¬Ôò·µ»Øcheck_expression ......