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 ServerÖÐʹÓÃNewID()·½·¨²úÉúËæ»ú¼¯
ÀýÈ翼ÊÔϵͳÖеÄËæ»ú³öÌâ
¸Õ¿ªÊ¼Ïëµ½µÄÊÇRandomÀà
µ«ÊÇRandomЧÂÊÓеãµÍ
ºóÀ´Ïëµ½ÁËÔÚÊý¾Ý¿âÀïµÄnewid()
ÓÚÊDzÉÓÃÁËϱ߷½·¨£º
select top 5 * from tablename order by newid()
Ôڴ˱ê¼ÇһϠ......
use Master
go
if object_id('SP_SQL') is not null
drop proc SP_SQL
go
create proc [dbo].[SP_SQL](@ObjectName sysname)
as
set nocount on ;
declare @Print varchar(max)
if exists(select 1 from syscomments where ID=objec ......
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 ......
ÄãÊÇ·ñÔÚǧ·½°Ù¼ÆÓÅ»¯SQL Server Êý¾Ý¿âµÄÐÔÄÜ?Èç¹ûÄãµÄÊý¾Ý¿âÖк¬ÓдóÁ¿µÄ±í¸ñ£¬°ÑÕâЩ±í¸ñ·ÖÇø·ÅÈë¶ÀÁ¢µÄÎļþ×é¿ÉÄÜ»áÈÃÄãÊÜÒæ·Ëdz¡£SQL Server 2005ÒýÈëµÄ±í·ÖÇø¼¼Êõ£¬ÈÃÓû§Äܹ»°ÑÊý¾Ý·ÖÉ¢´æ·Åµ½²»Í¬µÄÎïÀí´ÅÅÌÖУ¬Ìá¸ßÕâЩ´ÅÅ̵IJ¢Ðд¦ÀíÐÔÄÜÒÔÓÅ»¯²éѯÐÔÄÜ¡£
¡¡¡¡SQL ServerÊý¾Ý¿â±í·ÖÇø²Ù×÷¹ý³ÌÓÉÈý¸ö²½Öè×é³É£º
¡ ......