¶Á¡¶SQL Server 2005¸ß¼¶¹ÜÀí¡·µÄһЩժҪ... Á¬ÔØ
¹ØÓÚDBAµÄ½ÇÉ«
Éú²úDBA
ÊôÓÚ´«Í³DBA½ÇÉ«£¬Êǹ«Ë¾µÄ‘±£µ¥’£¬È·±£Éú²úÊý¾Ý²»»á³ö´í¡£»¹¸ºÔðÈ·±£·þÎñÆ÷Ò»×îÓÅ»¯µÄ·½Ê½ÔËÐУ¬²¢´Ù½øÊý¾Ý¿â´Ó¿ª·¢ÆÚתµ½QAÔÙתµ½Éú²ú¡£
Éú²úDBAµÄÆäËûһЩ½ÇÉ«°üÀ¨ÒÔÏ·½Ã棺
1£© °²×°SQL Server ʵÀýºÍ²¹¶¡°ü¡£
2£© ¼àÊÓÐÔÄÜÎÊÌâ¡£
3£© °²×°À´×Ô¿ª·¢ÈËÔ±µÄ½Å±¾¡£
4£© ½¨Á¢ÐÔÄÜÖ¸±êµÄ»ù×¼¡£
5£© ÓÅ»¯ÅäÖÃSQL Server.
6£© ½¨Á¢ÔÖÄѻָ´ºÍÉìËõÐԼƻ®¡£
7£© È·±£±¸·ÝÕý³£ÔËÐС£
ÔÚ´óÐ͵¥Î»ÖУ¬Éú²úDBA¿ÉÄÜÊôÓÚÔËÓª²¿ÃÅ£¬½«Éú²úDBA·Å½ø¿ª·¢Ð¡×éÖн«Ê¹µÃÎÞ·¨ÊµÏÖÓÉÓÚ·¨¹æÔÒòËùÐèµÄȨÏÞ·ÖÀë¡£Ëü´´½¨Ò»ÖÖ»·¾³:¿ª·¢ÈËÔ±Ëù×÷µÄÐÞ¸ÄÁ¢¼´Ó¦Óõ½Éú²ú»·¾³ÖУ¬¶øÇÒûÓнøÐÐÊʵ±µÄ¼ì²éºÍÉóºË¡£
¿ª·¢DBA
ËûÃÇÊÇ¿ª·¢ÈËÔ±µÄÊý¾Ý¿âר¼ÒºÍ´ú±í£¬È·±£ËùÓд洢¹ý³Ì¶¼ÒÔ×îÓÅ·½Ê½±àд£¬²¢È·±£Êý¾Ý¿âÔÚÎïÀíºÍÂß¼É϶¼ÕýÈ·½¨Ä£¡£»¹¸ºÔðǨÒƹý³Ì£¬
¿ª·¢DBAµÄÆäËûһЩ½ÇÉ«°üÀ¨ÒÔÏ·½Ã棺
1£© Ó¦ÓÃÊý¾Ý¿â½¨Ä£¡£
2£© ´´½¨´æ´¢¹ý³Ì¡£
3£© ¿ª·¢Éú²úDBAʹÓõĸü¸Ä½Å±¾¡£
4£© ¶Ô²éѯºÍ´æ´¢¹ý³Ì½øÐÐÐÔÄÜÓÅ»¯¡£
5£© ¿ÉÄÜ´´½¨ÈκαØÒªµÄÊý¾ÝǨÒÆ¡£
6£© ×÷ΪÉú²úDBAµÄÒ»¸öÉý¼¶µã¡£
ÔÚ´«Í³ÒâÒåÉÏ£º¿ª·¢DBA²»Ó¦¶ÔÉú²úÊý¾Ý¿âµÄÐÞ¸ÄȨÏÞ¡£È»¶øËûÃÇÓ¦¸ÃÄܹýÒÔÖ»¶Á·½Ê½·ÃÎÊÉú²úÊý¾Ý¿âÒÔ±ã¿ìËٵؽøÐе÷ÊÔ¡£
ÉÌÒµÖÇÄÜDBA£¨BI DBA£©
ÊÇËæSQL ServerÍâΧӦÓò»¶ÏÔö³¤¶ø³öÏÖµÄÒ»ÖÖнÇÉ«¡£
ÔÚSQL ServerÁìÓò£¬BI DBA¸ºÔðÈçÏÂÀàÐ͵ŦÄÜ£º
1) ¿ª·¢Êý¾ÝǨÒÆ°ü¡£
2) Analysis Servers¶àάÊý¾Ý¼¯ºÍ½â¾ö·½°¸½¨Ä£¡£
3) Óë·ÖÎöÈËÔ±ºÏ×÷ΪBussiness Scorecard Manager ¿ª·¢KPIÖ¸±ê¡£
4) ʹÓÃReporting Servers´´½¨±¨±í¡£
5) ¿ª·¢Notification Servers½â¾ö·½°¸¡£
6) ʹÓÃIntegration Servers´´½¨ETL.
7) ¿ª·¢½«Òª·¢Ë͸øÉú²úDBAµÄ²¿Êð³ÌÐò°ü¡£
Ò»°ã¶øÑÔ£¬BI DBAͨ³£Ïò¿ª·¢Ð¡×é»ã±¨¡£ÔÚÓÐAnalysis Serversר¼ÒµÄÇé¿öÏ£¬ËûÃÇ¿ÉÄÜÏò·ÖÎöС×é»òÏîÄ¿¹ÜÀí°ì¹«Êһ㱨¡£ÔÚÓÐЩ½ÏСµÄµ¥Î»£¬BI DBA¿ÉÄÜÖ±½ÓÏò¸ß¹Ü»ã±¨¡£
»ìºÏDBA
DBA×îÁîÈËÕñ·ÜµÄ½ÇÉ«ÊÇÇ°ÃæÌáµ½µÄ¸÷ÖÖ½ÇÉ«µÄ»ìºÏ¡£ÕâÖÖ»ìºÏDBAÔÚСÐ͵¥Î»·Ç³£³£¼û£¬ÈËÔ±Á÷¶¯Æµ·±µÄµ¥Î»¿ÉÄÜÊ
Ïà¹ØÎĵµ£º
1¡¢Óëgroup by´îÅäʹÓõĺ¯Êý
ÔÚÊý¾Ý¿âÖУ¬ÎÒÃÇ¿ÉÒÔʹÓÃGROUP BYº¯Êý°ÑÊý¾Ý×éºÏÔÚÒ»Æ𣬴Ӷø»ñµÃ×ܼÆÐÅÏ¢¡£¿ÉÒ԰Ѵ˹¦ÄÜ¿´³ÉÊÇÒ»ÖÖµ±Êý¾Ý´ÓÊý¾Ý¿âÖзµ»Øʱ°ÑÏàͬÀàÐ͵ÄÐÅÏ¢¼¯Öе½Ò»ÆðµÄÄÜÁ¦¡£ÏÂÃæ¸ø³öÁËÍêÕûÁÐ±í¡£
avg([distinct]column_name)
ÇóËùÓйÍԱнˮµÄƽ¾ùÖµ¡£
select AVG(emp_salary)
from employee;
ÇóÈ¡c ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssql
Óï¾ä£¬²»¿ÉÒÔÔÚaccess
ÖÐʹÓá£
SQL
·ÖÀࣺ
DDL—
Êý¾Ý¶¨ÒåÓïÑÔ(CREATE
£¬ALTER
£¬DROP
£¬DECLARE)
DML—
Êý¾Ý²Ù×ÝÓïÑÔ(SELECT
£¬DELETE
£¬UPDATE
£¬INSERT)
DCL—
Êý¾Ý¿ØÖÆÓïÑÔ(GRANT
£¬REVOKE
£¬COMMIT
£¬ROLLBACK)
Ê×ÏÈ,
¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1
¡¢ËµÃ÷£º ......
http://www.umgr.com/blog/PostView.aspx?bpId=36294
1. Ö´ÐÐsqlÓï¾ä
int sqlite3_exec(sqlite3*£¬ const char *sql£¬ sqlite3_callbacksql Óï·¨
£¬ void *£¬ char **errmsg );
Õâ¾ÍÊÇÖ´ÐÐÒ»Ìõ sql Óï¾äµÄº¯Êý¡£
µÚ1¸ö²ÎÊý²»ÔÙ˵ÁË£¬ÊÇÇ°Ãæopenº¯ÊýµÃµ½µÄÖ¸Õ롣˵ÁËÊǹؼüÊý¾Ý½á¹¹¡£
µÚ2¸ö²ÎÊýconst char ......
SQLÈÕÆÚ¸ñʽ»¯
0 »ò 100 (*) ĬÈÏÖµ mon dd yyyy hh:miAM£¨»ò PM£©
1 101 ÃÀ¹ú mm/dd/yyyy   ......
package com.itcast.service.base;
import java.util.LinkedHashMap;
import javax.persistence.Entity;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import org.springframework.transaction.annotation.Propagation;
import org.spri ......