SQL server
m0_37121645
这个作者很懒,什么都没留下…
展开
-
sql server 有关 insert into select into
--要求目标表存在 insert into 目标表 select* from 原表 --insert into T_Branch_Data_temp --select * from [T_Branch_Data] --目标表不存在select* into 目标 from 原表 --select * --into T_Branch_Data_temp --from [T_Branch_Data]...原创 2021-06-24 15:27:22 · 175 阅读 · 0 评论 -
sqlserver case when 判断null
sqlserver case when 判断null主要代码select case when sub.JsonData is NULL then tem.JsonDataelse sub.JsonData end as JsonData,case when sub.JsonData is NULL then ‘1’else ‘0’ end as IsSubJson, sub.ID as subId,tem.ID as temID from T_table_subject as原创 2021-04-26 11:15:04 · 1939 阅读 · 0 评论