![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql server 语句记录
m0_51184974
这个作者很懒,什么都没留下…
展开
-
SQL server 两个字段连接在一起
两个字段拼接时对字段的类型会有限制,需用转换函数进行修改1、convertconvert(VARCHAR(500),REM)2、CASTCAST(REM AS VARCHAR(500))两个字段连接1、+号关联PS_NO+CAST(REM AS VARCHAR(500))2、CONCATCONCAT(PS_NO,convert(VARCHAR(500),REM))...原创 2021-01-26 14:11:46 · 9464 阅读 · 0 评论 -
SQLserver 多行合并为一行
将表和插入模拟数据CREATE TABLE #TEST(ID INT,course VARCHAR(255))INSERT INTO #TEST VALUES(1,'语文')INSERT INTO #TEST VALUES(2,'数学')INSERT INTO #TEST VALUES(3,'英语')INSERT INTO #TEST VALUES(4,'英语')INSERT INTO #TEST VALUES(4,'英语')INSERT INTO #TEST VALUES(4,'英语1原创 2021-01-26 10:45:11 · 2127 阅读 · 0 评论 -
SQL SERVER查重复
同表单字段select * from test_hangzhuanliewhere BRANCH_CODE in (select BRANCH_CODE from test_hangzhuanlie group by BRANCH_CODE having count(BRANCH_CODE) > 1)不同表单字段 select * from tb where name in (select stunm from student group by stunm having c原创 2020-10-13 09:26:49 · 335 阅读 · 0 评论