sqlserver ´¥·¢Æ÷ÎÊÌâ
ÎÒÏë×öÒ»¸ö´¥·¢Æ÷£¬µ«Ð޸ıíTµÄ×Ö¶ÎC1ʱ£¬ÅжÏÈç¹ûÐ޸ĺóµÄֵΪ-1£¬Ôò¸üбíT¸ÃÐмǼµÄ×Ö¶ÎC2Ϊijֵ¡£
CreateTRIGGER [Tri_UpdateLastSaveDate] ON [dbo].[T]
for UPDATE
AS
BEGIN
if update(C1)
begin
if inserted.C1='-1'
begin
update T set C2=convert(varchar,getdate(),21)
where C3=(select C3 from inserted);
end
end
END
¿ÉÊÇÖ´ÐеÄʱºò×ÜÊDZ¨´í£º
No row was updated.
Error Source:Microsoft.VisualStudio.DataTools.
Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(2 rows)
±íTûÓÐÖ÷¼ü£¬ÇÒC3×Ö¶Îʵ¼ÊÊÇΨһֵ
ÎÒ°ÑupdateÕâ¾ä»°È¥µô£¬Ð½¨ÁËÒ»¸ö±íAA£¬°üº¬×Ö¶Îc1¡¢c2£¬Ò²Ã»ÓÐÖ÷¼ü¡£
Ìæ»»³Éupdate AA set AA.C1='99' from AA,Inserted
where AA.C1=Inserted.C1
¿ÉÊÇ»¹ÊÇÌáʾÕâÑùµÄ´íÎó¡£
Çë°ïæ½â¾ö£¬×ż±¡£Ð»Ð»¡£
SQL code:
CreateTRIGGER [Tri_UpdateLastSaveDate] ON [dbo].[T]
for UPDATE
AS
BEGIN
if update(C1)
begin
update T set C2=convert(varchar,getdate(),21)
from T,inserted i
where T.C3=i.C3
and i.C1='-1';
end
END
SQL code
Code highlighting produced by Actipro CodeHighlighter (freeware
Ïà¹ØÎÊ´ð£º
ÎÒÔ±¾ÊÇÓÃACCESSµÄÊý¾Ý¿â£¬ÏÖÔÚ¸ÄÓÃSQLServer2005ÁË£¬ËùÒÔÏë°Ñ֮ǰµÄÊý¾ÝÈ«¶¼µ¼µ½SQLSERVERÀïÀ´¡£
ÏÖÓÐÎÊÌâÈçÏ£º
1:¸ÄÓÃSQLserverºó£¬Êý¾Ý¿âµÄ½á¹¹Óи͝¡£Ô±¾ÔÚaccessÖÐËùÓеĵ¥¾ÝÓÃÒ»¸ö¡°µ¥¾ÝÐÅÏ¢¡±Ö ......
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
´úÂ룺
insert into openrowset('microsoft.ace.oledb.12.0','excel 12.0;hdr=yes;database=d:\a.xslx','select * from [sheet1$]') select * from table
×¢Ò⣺µ¼³öµÄÊý¾ÝºÍ±íÍ·ÒªÒ» ......