摘要: -- 删除索引 ALTER TABLE createworkflow DROP CONSTRAINT pk_createworkflow_id; -- 修改字段长度Alter table createworkflow alter column id varchar(64) not null; -- 阅读全文
posted @ 2021-04-08 19:42 2021冲鸭 阅读(1049) 评论(0) 推荐(0) 编辑
摘要: select case when charindex('`~`8',typename)>0 then SUBSTRING(typename,7,charindex('`~`8',typename)-7) else typename end,case when charindex('`~`8',wor 阅读全文
posted @ 2021-04-08 18:45 2021冲鸭 阅读(687) 评论(0) 推荐(1) 编辑