![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql server
wangchunyu506
这个作者很懒,什么都没留下…
展开
-
SQL Server怎样更改时间 sql 语句
update table set tayaoqiubanfutime='2017-09-30 '+CONVERT(varchar(12),convert(datetime,tayaoqiubanfutime), 14)where id = '8a8481a33c13a31c013c140778cb0026'转载 2017-09-15 18:25:18 · 3611 阅读 · 0 评论 -
oracle一行变多行
SELECT REGEXP_SUBSTR('1,2,3,4,5,6,7,8,9', '[^,]+', 1, ROWNUM) FROM DUAL CONNECT BY ROWNUM <= LENGTH('1,2,3,4,5,6,7,8,9') - LENGTH(REPLACE('1,2,3,4,5,6,7,8,9', ',', '')) + 1转载 2018-03-01 17:41:12 · 3251 阅读 · 0 评论