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

sql 2000 ¹ÒÆð

¹ØÓÚ£ºÒÔǰµÄij¸ö³ÌÐò°²×°ÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷ ½â¾ö°ì·¨
ÒÔǰװ¹ýsql server£¬ºóÀ´É¾µô¡£ÏÖÔÚ֨װ£¬È´³öÏÖ“ÒÔǰµÄij¸ö³ÌÐò°²×°ÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷¡£ÔËÐа²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú”´íÎó¡£ÎÞ·¨½øÐÐÏÂÈ¥¡£
   ²½ÖèÊÇ£º
   1£©Ìí¼Ó/ɾ³ý³ÌÐòÖг¹µ×ɾ³ýsql server¡£
   2£©½«Ã»ÓÐɾ³ýµÄsql serverĿ¼Ҳɾ³ýµô¡£
   3) ²á±í±à¼­Æ÷£¬ÔÚHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session ManagerÖÐÕÒµ½PendingFileRenameOperationsÏîÄ¿£¬²¢É¾³ýËü¡£ÕâÑù¾Í¿ÉÒÔÇå³ý°²×°ÔݹÒÏîÄ¿¡£
   4) ²á±íÖиúsql serverÏà¹ØµÄ¼ü¡£
    Æäʵ¹À¼ÆÖ»Òª×öµÚ3²½¾Í¿ÉÒԸ㶨£¬ÕâÑù¾Í¿ÉÒÔÇå³ý°²×°ÔݹÒÏîÄ¿¡£×Ô¼ºÊÇÏÈ×ßÁË1£¬2£¬4£¬×îºó×öÁË3²Å¸ã¶¨¡£ËùÒÔ¹À¼Æ3²ÅÊÇ×î¹Ø¼üµÄ.


Ïà¹ØÎĵµ£º

SQL Êý¾Ý¿â¿ª·¢Ò»Ð©¾«µäµÄ´úÂë

1.°´ÐÕÊϱʻ­ÅÅÐò: Select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
2.Êý¾Ý¿â¼ÓÃÜ: select encrypt('ԭʼÃÜÂë') select pwdencrypt('ԭʼÃÜÂë') select pwdcompare('ԭʼÃÜÂë','¼ÓÃܺóÃÜÂë') = 1--Ïàͬ£»·ñÔò²»Ïàͬ
3.È¡»Ø±íÖÐ×Ö¶Î: declare @list varchar(1000),@sql nvarchar(1000)&n ......

¶¯Ì¬sqlÓï¾ä»ù±¾Óï·¨

  
  ¶¯Ì¬sqlÓï¾ä»ù±¾Óï·¨    
  1   :ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃExecÖ´ÐÐ    
   
  eg:       Select   *   from   tableName    
                    Exec( ......

Ò»¸öÌâÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä


×ªÔØËµÃ÷£º¸øÕýÔÚ×öϵͳºÍÏë×öϵͳµÄÈË£¬SQL²©´ó¾«ÉÄãÃÇ»áÓõ½µÄ¡£——mAysWINd
Ò»¸öÌâÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ