![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlserver
claudxyz
Thought is already is late, exactly is the earliest time.
展开
-
SQLSERVER 列转行
<br />SELECT PROJECT_ID,STAGE_CLASS,QUARTER,PROFILE<br /> FROM<br /> T_AM_BUILD_INFO<br /> UNPIVOT<br /> (<br /> PROFILE<br /> FOR QUARTER IN<br /> ([OLD_PROPERTY_ID],[NEW_PROPERTY_ID],[OLD_ADDR_ID],[NEW_ADDR_ID])<br />原创 2010-07-15 16:50:00 · 182 阅读 · 0 评论 -
通过使用openrowset来读取excel
通过使用openrowset来读取excel--打开权限exec sp_configure 'show advanced options',1 reconfigure exec sp_configure 'Ad Hoc Distributed Queries',1 reconfigure select * from OpenRowSet( 'Microsoft.Jet.OLEDB.4.0','EXCEL 8.0;HDR=yes;User ID=Admin;Password=;IMEX=1;D原创 2010-06-02 16:41:00 · 266 阅读 · 0 评论 -
区间段月第一天,最后一天,该月年最后一天
DECLARE @START BIGINTDECLARE @END BIGINTSET @START=1980SET @END=2063DECLARE @Y_TB TABLE( YEAR INT) DECLARE @M_TB TABLE( MONTH INT) WHILE @START BEGIN INSERT IN原创 2011-06-29 21:11:00 · 207 阅读 · 0 评论