码到成功

摘要： select c.serial_number,b.mold_no,MAX(c.apply_time ) as apply_time ,stuff((select ','+wm_apply_mac_reason.apply_reason from wm_apply_mac_reason where serial_number=a.serial_number for xml path('')),1,1,'')as apply_reason, max(c.apply_name),c.apply_bz,stuff((select ','+ 阅读全文

摘要： 添加新列ALTER TABLE [wuliaoinfo] ADD [pdrq] [datetime] NULL修改类型ALTER TABLE TableName1 ALTER COLUMN FieldName1 CHAR(100) 删除列ALTER TABLE dbo.doc_exb DROP COLUMN alter table 表名 drop constraint 主键名alter table [wm_mac_repair] drop constraint [wm_mac_repair] 阅读全文