LuYanLin_的博客

select * from openquery(数据库名,'select * from 表')错误语句：`select * from openquery(数据库名,'select * from 数据库名.dbo.表')`

CONCAT()函数，里面是拼接的参数update BPMI_TASK set TaskName= CONCAT('【',InitUserName,'】','出差申请') where ProcessName='出差申请' and TaskName like '%【】%'

update TravelApply set TravelApply.ApplyUser=swsmu_bpmdb.dbo.BPMU_USER.DspName ,TravelApply.UserName=swsmu_bpmdb.dbo.BPMU_USER.DspName from swsmu_bpmdb.dbo.BPMU_USERwhere TravelApply.ApplyUser='' and TravelApply.ApplyAccount=swsmu_bpmdb.dbo.BPMU_USE

case when a.DiningPlan =1 then '早餐' when a.DiningPlan =2 then '午餐' when a.DiningPlan =3 then '晚餐' when a.DiningPlan =4 then '其他' end ,select b.ClaimNo, a.Department,a.Master,a.TreatTime,case when a.DiningPlan =1 then '早餐' when a.DiningPlan =2 then '午餐'

当替换的字符串里面有单引号时会报错，这时候就要用两个单引号代替字符串中的一个单引号。会报错的语句：UPDATE UserMenu SET Html= replace (Html, ‘采购流程’, '采购流程协同专项申报' )不会报错的语句：UPDATE UserMenu SET Html= replace (Html, ‘采购流程’, '采购流程协同专项申报' )...

SQL 关联表Updateupdate a set a.TaskName=b.TaskName from BPMI_TASK a,BPMI_TOKENLAST b where a.TaskId=b.TaskId and a.TaskName like ‘%费用管理%’select (select top 1 TaskName from BPMI_TOKENLAST b where b.TaskId=a.TaskId),* from BPMI_TASK a where a.T

update Sys_TableMapset Name = REPLACE(Name, ‘申万菱信基金管理有限公司’, ‘申万菱信’)

创建唯一约束alter table 表名 add constraint 约束名(自定义) unique(字段)举例：alter table DiDiCarBill add constraint qw unique(CarOrderNumber)查询重复数据select * from 表 where 要查询的字段 in (select 要查询的字段 from 表 group ...

1、2、3、4、5、

alter table SpecialDeclaration ADD PlanBuyTime [datetime] NULL Default 0EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’预购日期’ , @level0type=N’SCHEMA’,@level0name=N’dbo’, @level1typ...

INSERT INTO 表名称 VALUES ()Excel表转化数据格式=CONCATENATE("(’",A2,"’,’",B2,"’,’",C2,"’,’",D2,"’,’",E2,"’,’",F2,"’,’",G2,"’,’",H2,"’,’",I2,"’,’",J2,"’,’",K2,"’,’",L2,"’,’",M2,"’),")1、粘贴：2、得出数据3、插入空数据=CO...