sql
粗糙的汉子
这个作者很懒,什么都没留下…
展开
-
Sql server 13位时间戳转换日期格式
Select CONVERT(varchar(100), DATEADD (MS ,1642581564742 % 60000 ,DATEADD(MI,1642581564742 / 60000,'1970-01-01 08:00:00')), 23)原创 2022-01-21 12:46:42 · 1796 阅读 · 0 评论 -
Sql server 分页
//公示select * from (select ROW_NUMBER() OVER(Order by uid ) AS RowNumber,uid from tb_asset_kpdj) as bwhere RowNumber BETWEEN (页数-1)*条数+1 and 页数*条数 //示例 以第一页为例select * from (select ROW_NUMBER() OVER(Order by uid ) AS RowNumber,uid from tb_asset_kpdj).原创 2021-07-23 10:06:38 · 156 阅读 · 0 评论 -
SQL Server插入人员 解决自增长id
set IDENTITY_INSERT tb_jc_user ONINSERT INTO tb_jc_user(uid, xm, account, mob, ryjs, avatar, zw, psw) VALUES (23, '桂晋', '1111','1111', 2, NULL, NULL, '123456');set IDENTITY_INSERT tb_jc_user OFF原创 2021-07-14 13:46:08 · 345 阅读 · 0 评论 -
MySql字符串拆分多条数据,序号自增长
根据特定字符将一条数据拆分成多条数据原始数据处理结果SQL语句SELECT a.id, a. NAME, substring_index( substring_index( a.shareholder, ',', b.help_topic_id + 1 ), ',' ,- 1 ) AS shareholderFROM company aJOIN mysql.help_topic b ON b.help_topic_id < (转载 2020-10-19 12:58:26 · 263 阅读 · 0 评论 -
sql 子级拼接父级
select A.*,case when (select count(*) from tb_jc_xz B where A.parentid = B.uid) >0then cast((select B.mc from tb_jc_xz B where A.parentid = B.uid) as VARCHAR)+'-'+A.mc else A.mc end as id fro...原创 2020-02-10 19:52:50 · 641 阅读 · 0 评论 -
最近3年
原创 2020-02-10 19:53:11 · 183 阅读 · 0 评论 -
sql 连续3年
将日期转换成年 比如2019-10-11(2019) - 2018-10-11(2018)select a.lx,a.rq from tb_da_hj a left join tb_da_hj b on a.emid=b.emid and datediff(mm,a.rq+ '-01',getdate())/12>datediff(mm,b.rq+ '-01',getdate())...原创 2020-02-10 19:53:01 · 771 阅读 · 0 评论 -
年龄转换成 **周(周岁)**月**日
select cast(datediff(mm,csdate+ '-01',getdate())/12 as varchar)+'年'+cast(case when datepart(dd,getdate())>=datepart(dd,csdate+ '-01') then datediff(mm,csdate+ '-01',getdate())%12 else datediff(mm...原创 2020-02-10 19:53:13 · 392 阅读 · 0 评论