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

SQL Server 2000½Ì²Ä¶ÁÊé±Ê¼Ç£¨1£©

  ºÜ¾Ã֮ǰ¾ÍÏëÒª°Ñ×Ô¼ºµÄ¶ÁÊé¹ý³Ì¼Ç¼ÏÂÀ´£¬½ñÌìÉÔ΢ÕûÀíÁËһϣ¬ÈÏΪ²»¹ÜʲôÊ飬×Ô¼ºÃ»ÔõôÍêÕûµØ¿´Í꣬¸ü±ðÌáÈÏÕæµØÈ«²¿µØ¿´ÍêÁË¡£ÌýÈË˵£¬ÒªÑ¡1±¾ºÃÊéÀ´¿´£¬ÎÒ²»·´¶ÔÕâÖÖ˵·¨£¬µ«¸üÖØÒªµÄÊÇ£¬²»½öÊÇÊé±¾Éí£¬¶øÊÇÎÒÃÇ×Ô¼ºµÄÇé¿ö£¬ÊDz»ÊÇÕæÕýͶÈë½øÈ¥¿´ÁË£¬²»¹ÜÔõÑù£¬Ð´ÊéµÄÈ˵Ä֪ʶ¿Ï¶¨±ÈÄãÕâ·½ÃæµÄ֪ʶҪ¶®ºÜ¶à£¬²»Òª×ÜÊÇÌôÌÞ£¬Òª·´Ê¡×Ô¼ºÊÇ·ñÕæµÄ¾²ÏÂÐÄÀ´È¥¿´ÍêÒ»±¾Êé¡£ºÃÁË£¬·Ï»°ÉÙ˵£¬ÏÂÃæÊÇÎҵĶÁÊé±Ê¼Ç£¬ÔÙ´ÎÇ¿µ÷ÊÇÎҵģ¬Õë¶ÔÎҵģ¬ÎÒ×Ô¼ºÐ´µÄ¡£
  ËùÓõÄÊé¾ÍÊÇÎÒÃÇÉϿεÄÓõĽ̲ģ¬¿´ÍêÁ˵Ú1ÕµÄÇ°4С½Ú¡£ÏÂÃæ¾ÍÕýʽ¿ªÊ¼°É£¡
  µÚ1ÕÂÊÇSQL Server 2000µÄ¸ÅÊö£¬¿ÉÒÔÈÃÎÒÃÇ´óÌåÁ˽âSQL Server 2000¡£
1.1»ù±¾Ãû´Ê½âÊÍ
1.1.1 ÓëÊý¾Ý¿âÏà¹ØµÄ¸ÅÄî
  ÖªµÀÁËʲôÊÇÊý¾Ý£¬Êý¾ÝµÄ¶¨Ò壬DBÊÇʲô£¬DBMSÓÖÊÇʲô£¬»¹ÓÐDBS
1.1.2 ¹ØϵÐÍÊý¾Ý¿â
  Á˽âÁËRDBMS£¬ÔÚRDBMSÖУ¬Êý¾ÝÆäʵ¾ÍÊÇ·ÖÃűðÀàµØ´æ´¢ÓÚ¸÷¸ö±íÖеģ¬±íÓë±íÖ®¼ä»áÓйØÁª£¬±íÊÇÓÉÐУ¨ÓÖ³ÆΪ¼Ç¼£©×é³ÉµÄºÍÁУ¨ÓÖ³ÆΪ×ֶΣ©×é³ÉµÄ¡£
1.1.3 ¿Í»§»ú/·þÎñÆ÷Ìåϵ¼Ü¹¹
  ÖªµÀÁËʲôÊÇÁ½²ãµÄC/S½á¹¹£¬Ê²Ã´ÊǶà²ãµÄC/S½á¹¹£¬Thick ClientºÍThin ClientÓÖÊÇʲô¡£
1.1.4 Transact-SQLÓïÑÔ
  ÖªµÀÁËʲôÊÇSQL£¬T-SQLÊÇSQL ServerËù²ÉÓõÄSQLÓïÑÔ£¬T-SQLÓïÑÔ¿É·ÖΪDDL£¬DML£¬DCL£¬DTLºÍT-SQLÐÂÔö¼ÓµÄÓïÑÔ¡£
1.2 SQL Server 2000¼ò½é
1.2.1 SQL Server 2000µÄ°æ±¾½éÉÜ
  ÖªµÀÁ˸÷ÖÖ²»Í¬°æ±¾Ö®¼äµÄÇø±ðºÍÌص㼰ËüÃÇËùÊÊÓõIJÙ×÷ϵͳ
1.2.2 SQL Server 2000Êý¾Ý¿â¹ÜÀíϵͳµÄÖ÷ÒªÌصã
ÓÐ8µã£¬²»Ò»Ò»ÁоÙÁË£¬Óм¸µã²»ÊǺÜÀí½â£¬ÒòΪÏÖÔÚ»¹Ã»Ñ§µ½ºóÃæÈ¥£¬È綯̬Ëø¶¨µÄ²¢·¢¿ØÖÆ£¬·á¸»µÄ±à³Ì½Ó¿Ú£¬ÏÖÔÚÖ»ÊÇ´óÌåÁ˽â°É¡£
1.3 SQL Server 2000µÄ°²×°
1.3.1 ÈíÓ²¼þ»·¾³ÒªÇó
1.3.2 °²×°¹ý³Ì
  ×Ðϸ¿´ÁËÊéÉϵIJåͼ£¬Ã÷È·ÁË°²×°¹ý³ÌºÍҪעÒâµÄһЩÎÊÌ⣬ºÍÒÔǰûÓÐ×¢ÒâµÄÎÊÌ⣬ÓÐÁËеÄÈÏʶÁË¡£
1.4 SQL Server·þÎñµÄÆô¶¯ºÍÍ£Ö¹
1.4.1 SQL ServerµÄ·þÎñÖÖÀà
1.4.2 ·þÎñ¹ÜÀíÆ÷
1.4.3 ͨ¹ýWindows 2000²Ù×÷SQL Server·þÎñ
  ½ñÌì¾Í¿´µ½ÕâÀïÀ´ÁË£¬¿´ÉÏÃæµÄ±Ê¼Ç£¬ÏñÊÇ°ÑĿ¼´òÁËÏÂÀ´°¡£¬²»¹ÜÁË£¬´òÏÂÀ´Ò²ÊǶÔ×Ô¼ºËù¿´µÄÒ»¸ö×ܽᣬÓÖÒ»¸ö֪ʶ½á¹¹£¬²»È»ÏñÒÔÇ°£¬Êé¿´ÍêÁË£¬Ê²Ã´Ò²Ã»ÓУ¬´óÄÔÀïÃ涼ÊÇÁãÉ¢µÄ֪ʶ£¬ÕâÑù×îÆðÂëÊÇÒ»¸ö¸´Ï°£¬ºÙºÙ£¬×îÖØÒªµÄÊÇÒª¼á³ÖÏÂÈ¥°¡£¡


Ïà¹ØÎĵµ£º

SQL Server 2000°²×°¹ÒÆðµÄ´¦Àí

¹ØÓÚSQL°²×°±»¹ÒÆðµÄÐÞ¸´´ó¼Ò¿ÉÄܶ¼Óöµ½¹ýµ±SQL±»É¾³ýºóÐèÒªÖØа²×°Ê±£¬½øÈë°²×°½çÃæ¾Í»á³öÏÖSQL´íÎóÌáʾ£º ´ÓÇ°µÄ°²×°³ÌÐò²Ù×÷ʹ°²×°³ÌÐò²Ù×÷¹ÒÆð£¬ÐèÒªÖØÐÂÆô¶¯¼ÆËã»ú
È»¶øÕâЩ¶¼Êǰ׷Ѿ¢£¬²»¹ÜÄãÖØÐÂÆô¶¯¶àÉÙ´ÎÒ²¶¼ÎÞ¼ÃÓÚÊ£¬ÏÂÃæÎҾͽ²½²ÔõÑùÄܹ»½â³ý°²×°»òÉý¼¶Ê±Îļþ±»¹ÒÆðµÄ²Ù×÷¡£
µã»÷ ¿ªÊ¼ ÔËÐÐ ÊäÈ룺regedit ......

SQLµÝ¹é²éѯº¯Êý

--²éѯ¸¸µ¥Î»µÄº¯Êý
CREATE Function GetParentUnit(@UnitId bigint, @Level int) 
Returns @Parents Table([UnitId] int ,[UnitName] nvarchar(64),[ParentUnitId] int) 
As 
Begin
    If @Level < 1 ......

SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓ㨶þ£©

SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓ㨶þ£©
×÷Õߣºfreedk
Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¸ÄÉÆSQLÓï¾ä
¡¡¡¡ºÜ¶àÈ˲»ÖªµÀSQLÓï¾äÔÚSQL SERVERÖÐÊÇÈçºÎÖ´Ðеģ¬ËûÃǵ£ÐÄ×Ô¼ºËùдµÄSQLÓï¾ä»á±»SQL SERVERÎó½â¡£±ÈÈ磺
select * from table1 where name=''zhangsan'' and tID > 10000
ºÍÖ´ÐÐ:
select * from table1 where tID > ......

SQLʱ¼ä¶Î²éѯ


SQLʱ¼ä¶Î²éѯ
ACCESSµÄ»°
select * from table where date1<#2008-1-20# and date2>#2007-8-30#
MYSQLµÄ»°
select * from table where date1<'2008-1-20' and date2>'2007-3-30'
Ò²¿ÉÒÔ
select * from table where date1 between '2008-1-20' and '2007-3-30'
ÆäÖÐdate1,date2¶¼ÊÇÈÕÆÚÀàÐ͵Ä× ......

OracleÖ´ÐÐSQLÓï¾äµÄ¹ý³Ì

µ±ÎÒÃÇÌá½»Ò»ÌõsqlÓï¾äʱ£¬oracle»á×öÄÄЩ²Ù×÷ÄØ£¿
Oracle»áΪÿ¸öÓû§½ø³Ì·ÖÅäÒ»¸ö·þÎñÆ÷½ø³Ì£ºservice process£¨Êµ¼ÊÇé¿öÓ¦¸ÃÇø·ÖרÓ÷þÎñÆ÷ºÍ¹²Ïí·þÎñÆ÷£©£¬µ±service process½ÓÊÕµ½Óû§½ø³ÌÌá½»µÄsqlÓï¾äʱ£¬·þÎñÆ÷½ø³Ì»á¶ÔsqlÓï¾ä½øÐÐÓï·¨ºÍ´Ê·¨·ÖÎö¡£
Ãû´Ê½âÊÍ£º
Óï·¨·ÖÎö£ºÓï¾ä±¾ÉíÕýÈ·ÐÔ¡£
´Ê·¨·ÖÎö£º¶ÔÕÕÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ