
sql server
jeremy_pg
前行
展开
-
表变量与临时表
<br />CREATE proc usp_kqmj <br />@st_date datetime, <br />@en_date datetime <br />as <br />select * into #tyskq from fpc_workrecord where rdate between @st_date and @en_date <br />update #tyskq <br /><br />set macno=ca原创 2010-06-15 08:13:00 · 662 阅读 · 0 评论 -
表变量与临时表
<br />CREATE proc usp_kqmj <br />@st_date datetime, <br />@en_date datetime <br />as <br />select * into #tyskq from fpc_workrecord where rdate between @st_date and @en_date <br />update #tyskq <br /><br />set macno=ca原创 2010-06-15 08:13:00 · 391 阅读 · 0 评论