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

SQL Server ÈÏÖ¤(Certification)

΢ÈíµÄÊý¾Ý¿âÈÏÖ¤´Ó°üÀ¨3¸ö·½ÃæµÄ£º
MCTS: Microsoft Certified Technology Specialist
MCITP: Microsoft Certified IT Professional
MCM: Microfot Certified Master.
 Î¢Èí½¨Òé²Î¼Ó×îа汾µÄÊý¾Ý¿âÈÏÖ¤¿¼ÊÔ£¬µ±Ç°°æ±¾ÊÇÖ¸Microsoft SQL Server 2008¡£
SQL Server2008 MCTS°üÀ¨3¸öÈÏÖ¤£º
1> SQL Server 2008 Implementation and Maintenace;
2> SQL Server 2008 Database Development;
3> SQL Server Business Intelligence Development and Maintenance.
SQL Server 2008 MCITP Ò²°üº¬3¸öÈÏÖ¤£º
1> Database Administrator IT Professional;
2> Database Developer IT Professional;
3> Business Intelligence Developer IT Professional.
MCITP±ÈMCTSÒª¿¼²ìµÄ·¶Î§¸ü¹ã£¬ÒªÇó¶ÔSQL Server 2008¼¼ÊõÁ˽âµÄ¸ü¾«Ï¸¡£ËùÒÔMCITPÒª±ÈMCTSÉÔ΢ÄѹýЩ¡£
MCMµ½2009Äê4Ô·ÝÈ«ÇòÖ»ÓÐ2¸öÈËͨ¹ýÁË¡£Õâ¸öÈÏÖ¤ÎÞÂÛÊǶԼ¼ÊõµÄÒªÇ󣬻¹ÊÇ»¨·ÑµÄ½ðÇ®¶¼ÊÇÏà¶Ô½Ï¸ßµÄ£¬ÕâÀï¾Í²»ÔÙÏêϸ½éÉÜÁË£¬ÓÐÐËȤµÄÅóÓÑ¿ÉÒÔ²ÎÕÕ
www.microsoft.com/learning/mcp/master/sql/default.mspx


Ïà¹ØÎĵµ£º

SQLÐÐתÁÐ ÁÐתÐÐ


--ÐÐÁл¥×ª
/****************************************************************************************************************************************************** 
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ×¶® ÕûÀíÈË£ºÖйú·ç
(Roy) 
ÈÕÆÚ
:2008.06.06 *************************************** ......

Sql Server»ù±¾º¯Êý

Ô­ÎĵØÖ·£ºhttp://www.programfan.com/article/2597.html
1.×Ö·û´®º¯Êý
³¤¶ÈÓë·ÖÎöÓÃ
datalength(Char_expr) ·µ»Ø×Ö·û´®°üº¬×Ö·ûÊý,µ«²»°üº¬ºóÃæµÄ¿Õ¸ñ
substring(expression,start,length) ²»¶à˵ÁË,È¡×Ó´®
right(char_expr,int_expr) ·µ»Ø×Ö·û´®ÓÒ±ßint_expr¸ö×Ö·û
×Ö·û²Ù×÷Àà
upper(char_expr) תΪ´óд
lower(c ......

°²×°SQL Sever 2008ʱ ´íÎó´úÂë: 1605 µÄ½â¾ö·½·¨


TITLE: SQL Server °²×°³ÌÐòʧ°Ü¡£
------------------------------
SQL Server °²×°³ÌÐòÓöµ½ÒÔÏ´íÎó:
MsiGetProductInfo ÎÞ·¨¼ìË÷ Product Code Ϊ“{95120000-00B9-0409-0000-0000000FF1CE}”µÄ°üµÄ ProductVersion¡£´íÎó´úÂë: 1605¡£¡£
Óöµ½Õâ¸ö´íÎóʱ£¬½â¾ö·½·¨ÈçÏ£º
µ±ÏµÍ³ÌáʾÈç {95120000-0 ......

»ñµÃÊý¾Ý¿âÃû³Æ///////²éѯÊý¾Ý¿âÀïËùÓбíµÄsqlÓï¾ä£¡

select   name   as   ¿âÃû   from   master..sysdatabases   where   dbid>=7 »ñµÃÊý¾Ý¿âÃû³Æ
select * from sysobjects where xtype='u' or xtype='v' ²éѯÊý¾Ý¿âÀïËùÓбíµÄsqlÓï¾ä£¡
select name from sysobjects where type='u' ²éѯһ¸ö¿ ......

ʹÓÃPL/SQL Developer¹¤¾ßµ¼ÈëexcelºÍµ¼³öexcel

µ¼³ö:
1.Ö´ÐÐ
select Óï¾ä²éѯ³öÐèÒªµ¼³öµÄÊý¾Ý.
2.ÔÚÊý¾ÝÁбíÖÐÓÒ¼ü,Ñ¡Ôñsave
results.±£´æÎª.csvÎļþ,È»ºóÒÑexcel·½Ê½´ò¿ª¾ÍOKÁË.¿ÉÒÔÁí´æÎªxsl¡£ÐèҪעÒâµÄÊÇÈç¹ûÁÐÄÚÈÝÊÇ´¿Êý×Ö
µÄ»°£¬µ¼³öʱ»á×Ô¶¯°ÑÇ°ÃæµÄ0È¥µô£¬ÏëÒªµ¼³öÍêÕûµÄÁÐÄÚÈÝ£¬×îºÃÕâÁеÄÄÚÈÝÆ´Ò»¸ö×Ö·ûÈ磺select  ‘#’||Column from ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ