|
鍐呭绠�浠�: |
? 鍩硅瀵硅薄:
1銆� 鎯抽�氳繃瀛︿範Sql Server 2005鏁版嵁搴撳揩閫熷氨涓氱殑澶у鐢熷拰鏈夊織闈掑勾
2銆� 鎯抽�氳繃瀛︿範Sql Server 2005鏁版嵁搴撴彁楂樿嚜韬湪浼佷笟涓珵浜夊姏鐨勪紒涓氬憳宸�
3銆� 鎯宠幏寰桵CTS銆丮CITP鍥介檯璁よ瘉鐨勬妧鏈汉鍛�
? 鍩硅鐩爣:
鐔熺粌鎺屾彙Sql Server 2005鏁版嵁搴撶殑寮�鍙戯紝鐔熸倝Sql Server 2005鏁版嵁搴撶殑绠＄悊
杈惧埌浼佷笟绾х敤浜虹殑鏍囧噯
? 鍩硅鍐呭:
鈥� T-SQL瀵硅〃鐨勬搷浣�
鈥� 瑙嗗浘
鈥� 瀛樺偍杩囩▼
鈥� 瑙﹀彂鍣�
鈥� 浜嬪姟鍜岄攣
鈥� WEB寮�鍙慡QL Server 2005鏁版嵁搴�
鈥� 鏁版嵁搴撶殑澶囦唤鍜岃繕鍘�
鈥� 鏁版嵁搴撶殑鍒嗙鍜岄檮鍔�
? 鍏蜂綋鍐呭濡備笅锛�
鏁版嵁搴撴搷浣滐細
鍒涘缓鍜屽垹闄�
琛ㄧ殑鍒涘缓鍜屾搷浣滐細
鈥� Select鏌ヨ鍛戒护
鈥� Select鏌ヨ
鈥� Where
鈥� AND 鐨剋here 瀛愬彞
鈥� Group by
鈥� Having
鈥� Order by
鈥� Top
鈥� Distinct
鈥� Between and
鈥� Like
鈥� In
鈥� Not in
鈥� 澶氳〃鏌ヨ
鈥� 鍏ㄨ繛鎺�
鈥� 宸﹁繛鎺�
鈥� 鍙宠繛鎺�
鈥� 鑱氬悎鍑芥暟
鈥� Avg
鈥� Sum
鈥� Count
鈥� Max
鈥� Min
瑙嗗浘锛�
鈥� 鍒涘缓瑙嗗浘锛坈reate view name锛�
鈥� 淇敼瑙嗗浘锛坅lter view name锛�
鈥� 鍒犻櫎瑙嗗浘锛坉rop view name锛�
瀛樺偍杩囩▼锛�
鈥� 鍒涘缓瀛樺偍杩囩▼锛坈reate procedure name锛�
鈥� 淇敼瀛樺偍杩囩▼锛坅lter procedure name锛�
鈥� 鍒犻櫎瀛樺偍杩囩▼锛圖rop procedure name锛�
鈥� 甯﹀弬鏁扮殑瀛樺偍杩囩▼
瑙﹀彂鍣細
鈥� 鍒涘缓瑙﹀彂鍣紙create trigger name锛�
鈥� 淇敼瑙﹀彂鍣紙alter trigger name锛�
鈥� 鍒犻櫎瑙﹀彂鍣紙Drop trigger name锛�
浜嬪姟鍜岄攣锛�
鈥� 浠�涔堟槸浜嬪姟
鈥� 骞跺彂鎬ч棶棰�
Sql Server 2005鏁版嵁搴撳簲鐢細
WEB寮�鍙慡QL Server 2005鏁版嵁搴�
? 鍩硅鏃堕棿锛氳90璇炬椂
鐧界彮锛氾紙鍛ㄤ竴鑷冲懆浜旂櫧澶╋級锛�15澶┿��27/10銆�28/11銆�29/12
鏅氱彮锛氾紙鍛ㄤ竴鑷冲懆浜旀櫄涓婏級锛�30澶┿��28/10銆�28/11銆�31/12
鍛ㄦ湯鐝紙鍛ㄥ叚銆佸懆鏃ヤ笂璇撅級锛�7涓崐鍛ㄦ湯銆�25/10銆�29/11銆�27/12
? 璐圭敤锛�6950鍏�-7000鍏�
鍩硅璐圭敤锛�4800鍏�/浜�
鑰冭瘯璐圭敤锛�1350鍏�/浜�
鏁欐潗璐圭敤锛�950鍏�/浜猴紙寮�鍙戠被锛夈��1000鍏�/浜猴紙绠＄悊绫伙級
濂楅锛堝惈鑰冭瘯銆佹暀鏉愩�佸煿璁級浼樻儬浠锋牸锛�6500鍏�/浜�
? 鍩硅鍦扮偣锛�
閲戞捣娲嬫暀鑲蹭腑蹇冿紙浜烘皯鍗楄矾鍥涙13鍙烽噾娴锋磱澶фゼ锛�
鍜ㄨ鐢佃瘽锛�85253871銆�85253872銆�85253873锛堢帇鏅撴収锛�
鍜ㄨQQ锛�983859902
浼犵湡锛�85253874
鍜ㄨ閭锛�
[email protected]
http://www.gocean.com.cn
|