<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="zh-Hant-TW">
	<id>http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=Trigger_COPTD.TD054</id>
	<title>Trigger COPTD.TD054 - 修訂紀錄</title>
	<link rel="self" type="application/atom+xml" href="http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=Trigger_COPTD.TD054"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=Trigger_COPTD.TD054&amp;action=history"/>
	<updated>2026-11-16T22:21:11Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=Trigger_COPTD.TD054&amp;diff=1585&amp;oldid=prev</id>
		<title>Root：​新頁面: == MOCTA TO LSDTEST.dbo.TATOCOPTD== &lt;sql&gt; CREATE TRIGGER TATOCOPTD ON MOCTA AFTER INSERT AS BEGIN INSERT INTO LSDTEST.dbo.TATOCOPTD (TD01,TD02,TD03,TD54) SELECT TA026,TA027,TA028,TA002...</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=Trigger_COPTD.TD054&amp;diff=1585&amp;oldid=prev"/>
		<updated>2015-12-24T08:04:38Z</updated>

		<summary type="html">&lt;p&gt;新頁面: == MOCTA TO LSDTEST.dbo.TATOCOPTD== &amp;lt;sql&amp;gt; CREATE TRIGGER TATOCOPTD ON MOCTA AFTER INSERT AS BEGIN INSERT INTO LSDTEST.dbo.TATOCOPTD (TD01,TD02,TD03,TD54) SELECT TA026,TA027,TA028,TA002...&lt;/p&gt;
&lt;p&gt;&lt;b&gt;新頁面&lt;/b&gt;&lt;/p&gt;&lt;div&gt;== MOCTA TO LSDTEST.dbo.TATOCOPTD==&lt;br /&gt;
&amp;lt;sql&amp;gt;&lt;br /&gt;
CREATE TRIGGER TATOCOPTD ON MOCTA&lt;br /&gt;
AFTER INSERT&lt;br /&gt;
AS&lt;br /&gt;
BEGIN&lt;br /&gt;
INSERT INTO LSDTEST.dbo.TATOCOPTD (TD01,TD02,TD03,TD54)&lt;br /&gt;
SELECT TA026,TA027,TA028,TA002 FROM MOCTA &lt;br /&gt;
LEFT JOIN LSDTEST.dbo.TATOCOPTD &lt;br /&gt;
ON TA026=TD01 AND TA027=TD02 AND TA028=TD03&lt;br /&gt;
WHERE MOCTA.CREATE_DATE=convert(char,getdate(),112) AND TD01 IS NULL&lt;br /&gt;
END&lt;br /&gt;
&amp;lt;/sql&amp;gt;&lt;/div&gt;</summary>
		<author><name>Root</name></author>
	</entry>
</feed>