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

½«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¡¢»á¿´µ½Õû¸ö²Ù×÷µÄÕªÒª£¬°´ Íê³É ¼´¿É¡£


Ïà¹ØÎĵµ£º

Sql Server»ù±¾º¯Êý

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¸ö¿Õ¸ñ ......

Sqlº¯Êý´óÈ«

---·µ»Ø±í´ïʽÖÐÖ¸¶¨×Ö·ûµÄ¿ªÊ¼Î»ÖÃ
select charindex('c','abcdefg',1)
---Á½¸ö×Ö·ûµÄÖµÖ®²î
select difference('bet','bit')
---×Ö·û×î×ó²àÖ¸¶¨ÊýÄ¿
select left('abcdef',3)
---·µ»Ø×Ö·ûÊý
select len('abcdefg')
--ת»»ÎªÐ¡×Ö·û
select lower('ABCDEFG')
--È¥×ó¿Õ¸ñºó
select ltrim('   &nbs ......

SQL Server 2008 ×èÖ¹±£´æÒªÇóÖØÐ´´½¨±íµÄ¸ü¸Ä


MS SQL Server 2008 ÔÚ½¨Íê±íºó£¬Èç¹ûÒª²åÈëÈÎÒâÁУ¬ÔòÌáʾ£º
µ±Óû§ÔÚÔÚSQL Server 2008ÆóÒµ¹ÜÀíÆ÷Öиü¸Ä±í½á¹¹Ê±£¬±ØÐëÒªÏÈɾ³ýÔ­À´µÄ±í£¬È»ºóÖØÐ´´½¨ÐÂ±í£¬²ÅÄÜÍê³É±íµÄ¸ü¸Ä£¬Èç¹ûÇ¿Ðиü¸Ä»á³öÏÖÒÔÏÂÌáʾ£º²»ÔÊÐí±£´æ¸ü¸Ä¡£ÄúËù×öµÄ¸ü¸ÄÒªÇóɾ³ý²¢ÖØÐ´´½¨ÒÔÏÂ±í¡£Äú¶ÔÎÞ·¨ÖØÐ´´½¨µÄ±ê½øÐÐÁ˸ü¸Ä»òÕ߯ôÓÃÁË“× ......

±¸·ÝºÍ»¹Ô­SQL Server¼°Ñ¹ËõAccessÊý¾Ý¿â

*
 * ¹¦ÄÜ˵Ã÷:±¸·ÝºÍ»Ö¸´SQL ServerÊý¾Ý¿â
 * ×÷Õß: Áõ¹¦Ñ«;
 * °æ±¾:V0.1(C#2.0);ʱ¼ä:2007-1-1
 * µ±Ê¹ÓÃSQL Serverʱ,ÇëÒýÓà COM×é¼þÖеÄ,SQLDMO.dll×é¼þ
 * µ±Ê¹ÓÃAccessÖÐ,Çëä¯ÀÀÌí¼ÓÒýÓÃÒÔÏÂÁ½¸ödll
 *          ÒýÓÃC:/Progra ......

SQLÖÐisnullº¯ÊýµÄÓ÷¨

Óï·¨£º
   isnull(check_expression,replacement_expression)
²ÎÊýcheck_expressionÓëreplacement_expressionÀàÐÍÐèÏàͬ
·µ»ØÖµ£º
   Èôcheck_expressionΪnull£¬Ôò·µ»Øreplacement_expression
   Èôcheck_expression²»Îªnull£¬Ôò·µ»Øcheck_expression ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ