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

SQL´¥·¢Æ÷ ʵÀý½Ìѧ


        ... 
      )
     Óõ½µÄ¹¦ÄÜÓÐ: 
        1.Èç¹ûÎÒ¸ü¸ÄÁËѧÉúµÄѧºÅ,ÎÒÏ£ÍûËûµÄ½èÊé¼Ç¼ÈÔÈ»ÓëÕâ¸öѧÉúÏà¹Ø(Ò²¾ÍÊÇͬʱ¸ü¸Ä½èÊé¼Ç¼±íµÄѧºÅ); 
        2.Èç¹û¸ÃѧÉúÒѾ­±ÏÒµ£¬ÎÒÏ£Íûɾ³ýËûµÄѧºÅµÄͬʱ£¬Ò²É¾³ýËüµÄ½èÊé¼Ç¼¡£ 
     µÈµÈ¡£
     Õâʱºò¿ÉÒÔÓõ½´¥·¢Æ÷¡£¶ÔÓÚ1£¬´´½¨Ò»¸öUpdate´¥·¢Æ÷£º
     Create Trigger truStudent 
       On Student                         --ÔÚStudent±íÖд´½¨´¥·¢Æ÷ 
       for Update                          --Ϊʲôʼþ´¥·¢ 
     As                                        --ʼþ´¥·¢ºóËùÒª×öµÄÊÂÇé 
       if Update(StudentID)            
       begin
         Update BorrowRecord 
           Set StudentID=i.StudentID 
           from BorrowRecord br , Deleted   d ,Inserted i      --DeletedºÍInsertedÁÙʱ±í 
           Where br.StudentID=d.StudentID
       end        
     Àí½â´¥·¢Æ÷ÀïÃæµÄÁ½¸öÁÙʱµÄ±í£ºDeleted , Inserted ¡£×¢ÒâDeleted ÓëInserted·Ö±ð±íʾ´¥·¢Ê¼þµÄ±í“¾ÉµÄÒ»Ìõ¼Ç¼”ºÍ“еÄÒ»Ìõ¼Ç¼”¡£ 
     Ò»¸öÊý¾Ý¿âϵͳÖÐÓÐÁ½¸öÐéÄâ±íÓÃÓÚ´æ´¢ÔÚ±íÖмǼ¸Ä¶¯µÄÐÅÏ¢£¬·Ö±ðÊÇ£º 
                             ÐéÄâ±íInserted                


Ïà¹ØÎĵµ£º

¾­µäSQLÓï¾ä´óÈ«

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......

sqlÊý¾Ýµ¼Èëµ¼³ö

´ó¼Ò´ò¿ªÕâ¸öÁ´½Ó¿ÉÒÔ¿´µ½ºÜ¶àÊý¾Ý¿âµÄÁ¬½Ó·½·¨¡£http://www.connectionstrings.com
ÕâЩÊý¾Ý¿âÖ®¼äµÄÊý¾Ý½»»»¾ÍÊÇÕâ¸öÌù×ÓËùÒª×ܽáµÄÄÚÈÝ¡£
£¨Ò»£©SQL ServerÖ®¼ä
°ÑÔ¶³ÌÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½±¾µØÊý¾Ý¿â¡£
http://community.csdn.net/Expert/topic/5079/5079649.xml?temp=.7512018
http://community.csdn.net/Expert/ ......

±È½ÏÁ½¸öSQLµÄÖ´ÐÐʱ¼ä

±È½ÏÁ½¸öSQLµÄÖ´ÐÐʱ¼ä
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PROC_SQL_COMP]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[PROC_SQL_COMP]
GO
/*--²âÊÔÁ½×éSQLµÄƽ¾ùʱ¼ä
 
 ÀûÓÃosql.exeÀ´²âÊÔÁ½×é SQL Óï¾äµÄÖ´ÐÐʱ¼ä
 ²âÊԵĴ洢¹ý³ ......

PL/SQLʵÀý·ÖÎö

PL/SQLʵÀý·ÖÎö
µÚÎåÕÂ
1¡¢PL/SQLʵÀý·ÖÎö
1£©ÔÚ¡¾SQLPlus Worksheet¡¿ÖÐÖ±½ÓÖ´ÐÐÈçÏÂSQL´úÂëÍê³ÉÉÏÊö²Ù×÷¡£(´´½¨±í)
¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D

CREATE TABLE "SCOTT"."TESTTABLE" ("RECORDNUMBER" NUMBER(4) NOT NULL, "CURRENTDATE" DATE NOT NULL)
TABLESPACE "SYSTEM ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ