Sql
关注
分享
扫一扫
明辉光焱
90后年轻码农
展开
-
sql 自增列归零
dbcc checkident('test',reseed,0)原创 2021-07-08 14:43:03 · 212 阅读 · 0 评论 -
批量修改部门名称（根据部门代码）update select
批量修改部门名称（根据部门代码）update dcc_internal_file set dcc_internal_file.dept_name=t_s_depart.departname from dcc_internal_file inner join t_s_depart on dcc_internal_file.dept_code=t_s_depart.id原创 2021-04-29 11:13:51 · 646 阅读 · 0 评论 -
SQL 将一列多行数据合并为一行
SELECT DISTINCT Name, STUFF((SELECT ',' + Course FROM Student WHERE Name = T.Name FOR XML PATH('')), 1, 1, '') AS Course FROM Student AS TSQL 将一列多行数据合并为一行原创 2020-03-20 09:56:12 · 696 阅读 · 0 评论