<?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=LINE_BOT_WM</id>
	<title>LINE BOT WM - 修訂紀錄</title>
	<link rel="self" type="application/atom+xml" href="http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=LINE_BOT_WM"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=LINE_BOT_WM&amp;action=history"/>
	<updated>2026-11-16T22:46:10Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=LINE_BOT_WM&amp;diff=3387&amp;oldid=prev</id>
		<title>Stanleyliu：​已建立頁面，內容為 &quot;&lt;SQL&gt; SELECT COPTD.CREATE_DATE+&#039; &#039;+COPTD.CREATE_TIME CR ,TD041,TD005,TD006,CAST(TD008 AS INT) TD008,CAST(SMC007 AS INT) SMC007, Convert(varchar,Convert(Datetime,TD01…&quot;</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=LINE_BOT_WM&amp;diff=3387&amp;oldid=prev"/>
		<updated>2019-03-20T04:42:56Z</updated>

		<summary type="html">&lt;p&gt;已建立頁面，內容為 &amp;quot;&amp;lt;SQL&amp;gt; SELECT COPTD.CREATE_DATE+&amp;#039; &amp;#039;+COPTD.CREATE_TIME CR ,TD041,TD005,TD006,CAST(TD008 AS INT) TD008,CAST(SMC007 AS INT) SMC007, Convert(varchar,Convert(Datetime,TD01…&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;新頁面&lt;/b&gt;&lt;/p&gt;&lt;div&gt;&amp;lt;SQL&amp;gt;&lt;br /&gt;
SELECT COPTD.CREATE_DATE+&amp;#039; &amp;#039;+COPTD.CREATE_TIME CR ,TD041,TD005,TD006,CAST(TD008 AS INT) TD008,CAST(SMC007 AS INT) SMC007,&lt;br /&gt;
Convert(varchar,Convert(Datetime,TD013,112),111) TD013,COPTD.UDF05 UDF05,MV002 FROM COPTD 	&lt;br /&gt;
	JOIN v_INVMC01 ON MC001=TD004 &lt;br /&gt;
	JOIN COPTC ON TC001=TD001 AND TC002=TD002&lt;br /&gt;
	JOIN CMSMV ON MV001=TC006&lt;br /&gt;
	WHERE TD002&amp;gt;&amp;#039;190319000&amp;#039; AND RTRIM(COPTD.UDF05)=&amp;#039;&amp;#039; AND TD001= 2201&lt;br /&gt;
&amp;lt;/SQL&amp;gt;&lt;/div&gt;</summary>
		<author><name>Stanleyliu</name></author>
	</entry>
</feed>