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ÖÐËùÓеĵ¥¾ÝÓÃÒ»¸ö¡°µ¥¾ÝÐÅÏ¢¡±Ö ......
±ÈÈçsqlÓï¾äÊÇ£º
SQL code:
select top 300
CA01.A_id as '±ä¶¯´ÎÊý',
CA01.A0188 as 'ÈËÔ±id',
CA01.apname as 'ÉóÅúÕß',
CA01.CA0100 as 'È·ÈÏ״̬',
CA01.CA0101 as '±ä¶¯ÀàÐÍ',
CA01.CA0102 as 'Éê ......
´úÂ룺
insert into openrowset('microsoft.ace.oledb.12.0','excel 12.0;hdr=yes;database=d:\a.xslx','select * from [sheet1$]') select * from table
×¢Ò⣺µ¼³öµÄÊý¾ÝºÍ±íÍ·ÒªÒ» ......
sqlserver´æ´¢¹ý³Ì¸Äoracle
˻ᰡ¡£¡£¡£°ïæ¸Ä¸Ä··
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE tp_Fetch_List(
  ......
ÔÊý¾Ý£º
¾¹ý´ËsqlÓï¾ä²éѯ³öÀ´µÄ½á¹ûÊÇ£º
SQL code:
select Code, Name=stuff((select ','+Name from C t where Code=C.Code for xml path('')), 1, 1, '')
from C
¼ÓÉÏG ......