SQLSERVER¼òµ¥´¥·¢Æ÷
INSERT´¥·¢Æ÷
INSERT¼°UPDATE´¥·¢Æ÷¾³£ÓÃÓÚ¼ì²â´¥·¢Æ÷Ëù¼à¿Ø±íµÄÁм°ÆäÊý¾ÝÊÇ·ñ·ûºÏËù¶¨ÒåµÄ¹æÔò¡£ËüÃÇ¿ÉÒÔÔÚÊý¾ÝÊäÈë±í֮ǰ£¬¶ÔÆä½øÐÐÔÚ¶¨ÒåÒýÓÃÍêÕûÐÔʱÎÞ·¨Íê³ÉµÄÔ¼Êø¼ìÑé¡£
ÏÂÃæÒÔѧÉúÊý¾Ý¿âstudentΪÀýÀ´½éÉÜINSERT´¥·¢Æ÷µÄʹÓ᣸ÃÊý¾Ý¿â°üÀ¨Èý¸ö±í£¬·Ö±ðÊÇÃèÊöѧÉúÇé¿öµÄ“ѧÉúµµ°¸”±í¡¢ÃèÊöѧÉú³É¼¨µÄ“ѧÉú³É¼¨”±ístudentºÍ¡£ÃèÊö·Ö×éÇé¿öµÄ“·Ö×éÇé¿ö”±ígro¡£
create table student (id numeric(1,0),name varchar(10),sex char(4),class varchar(10),gro numeric(1,0) )
create table gro (class varchar(10),gro numeric(1,0) ,num tinyint)
ΪÉÏÃæµÄ“ѧÉúµµ°¸” ±í´´½¨Ò»¸öINSERT´¥·¢Æ÷instrg£¬Æä×÷ÓÃÊÇÿÐÂÔöÒ»ÃûѧÉú¶øÐèÏò“ѧÉúµµ°¸”±íÖвåÈëÐÂÐÐʱ£¬ÔÚ“·Ö×éÇé¿ö”±íÖн«ÆäËùÔÚС×éµÄÈËÊý×Ô¶¯Ôö¼Ó1¡£
use mlh
Create Trigger instrg ON [dbo].[student]
FOR Insert
AS
declare @°à¼¶ varchar(50) ,@С×é varchar(50),@ÈËÊý tinyint
select @°à¼¶ = inserted.class,@С×é = inserted.gro from inserted
if exists(select num from gro where @°à¼¶ = gro.class and @С×é= gro.gro)
begin --bg1
select @ÈËÊý = num from gro where @°à¼¶= gro.class and @С×é = gro.gro
set @ÈËÊý = @ÈËÊý + 1
update gro set num = @ÈËÊý where @°à¼¶ = gro.class and @С×é = gro.gro
end --bg1
else
begin --bg2
insert gro values(@°à¼¶,@С×é,1)
end --bg2
UPDATE ´¥·¢Æ÷
Create Trigger stup On [dbo].[student]
FOR update
AS
Declare @°à¼¶ varchar(50) , @С×é numeric(1,0),@ÈËÊý tinyint
select @°à¼¶ = inserted.class ,@С×é= inserted.gro from inserted
if exists(select * from gro where @°à¼¶ = gro.class and @С×é = gro.gro)
begin
update gro set gro.num = gro.num + 1 where @°à¼¶ = gro.class and @С×é = gro.gro
end
else
begin
insert into gro values(@°à¼¶,@С×é,1)
end
select @°à¼¶ = deleted.class ,@С×é= deleted.gro from deleted
select @ÈËÊý = gro.num from gro where @°à¼¶ = gro.class and @С×é = gro.gro
if @ÈËÊý > 1
begin
&
Ïà¹ØÎĵµ£º
SQLServer´æ´¢¶àÓïÑÔÊý¾ÝµÄ¼¸ÖÖ·½·¨
http://www.examda.com/ncre/three/db/fudao/20100111/102352311.html
±¾ÎĸÅÊöÁËÔÚÊý¾Ý¿âÉè¼ÆÖУ¬ÈçºÎ´¦Àí¶à¹úÓïÑÔµÄÎÊÌ⣬ÕâÀïµÄ¶à¹úÓïÑÔÊÇÖ¸ÖîÈçÕâÑùµÄÒµÎñ£ºÔÚERPÈí¼þÖУ¬ÎÒÃÇÔÚÌîд¿Í»§Ãû³Æʱ£¬³ýÁËÐèÒªÌîд¿Í»§µÄÖÐÎÄÃû³Æ£¬»¹ÐèÒªÌîдËûµÄÓ¢ÎÄÃû³Æ¡£ Ò»°ãµÄ£¬Èç¹ûÊÇÆÕͨµÄÏîÄ¿ÐÍ ......
»°Ëµ°³ÊǸöÀÁÈË¡£¡£¡£¡£
×°ÍêSQLSERVER2005 ÒòΪ¿ª»úºÜÂý ËùÒÔÄؾͰѿª»ú·þÎñ¸ã³ÉÊÖ¶¯µÄÁË
ÕâÑù¿ª»ú¿ìÁ˺ܶà
¿ÉÊÇÎÊÌâÒ²À´ÁË
ÿ´ÎÒªÓÃSqlServerµÄʱºòÒªÒ»¸öÒ»¸ö·þÎñÈ¥¿ªÆðÀ´ ¡£¡£¡£¡£
Âé·³°¡¡£¡£¡£¡£¡£
²»±È2000Óиö ¿ª¹ØµÄ³ÌÐò
ËùÒÔÉÏÍøÕÒÁËϽ̳Ì
×Ô¼ºÐ´¸öÅú´¦Àí ×Ô¶¯Æô¶¯·þÎñ
ÍÛ¹þ¹þ
ͻȻ¾õµÃ Ö»ÒªÓÐÍ ......
SERVER Í£Ö¹,ÎÞ·¨Æô¶¯,¹ýÆÚÁË (ÆÀ¹À°æ2000)(2008-04-25 22:31:17)±êÇ©£ºsql server ÎÞ·¨Æô¶¯ ¹ýÆÚ ½â¾ö·½·¨ it
µ± SQL Server 2000 ÆÀ¹À°æµÄ 120 ÌìÆÀ¹ÀÆÚ¹ýÆÚºó£¬SQL Server ½«ÎÞ·¨Æô¶¯¡£
ÔÚ Windows ʼþ²é¿´Æ÷Ó¦ÓóÌÐòÈÕÖ¾ÖУ¬Äú¿ÉÄܻῴµ½ÏÂÃæµÄ´íÎó£º
SQL Server evaluation period has expired ......
ÔÚ SQLServer2005 ÖÐ¶Ô XML µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË query(),value(),exist(),modify(),nodes() µÈº¯Êý¡£
¹ØÓÚ xml £¬ÄÑÒÔÀí½âµÄ²»ÊÇ SQLServer ÌṩµÄº¯Êý£¬¶øÊÇ¶Ô xml ±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»ÊdzõÌ ......
SQLServer CodeSmith C#
bigint Int64   ......