11 lines
279 B
HTML
11 lines
279 B
HTML
|
|
|||
|
|
|
|||
|
|
<div id="sina_keyword_ad_area2" class="articalContent ">
|
|||
|
|
<div>with t as</div>
|
|||
|
|
<div>(</div>
|
|||
|
|
<div>select * from t_pub_param</div>
|
|||
|
|
<div>)</div>
|
|||
|
|
<div>select * from t</div>
|
|||
|
|
<div>SQL Server 2005 之后才可以使用，查询后临时表t会自动删除。</div>
|
|||
|
|
</div>
|
|||
|
|
|