常用的SQL更改和查询语句 select*,(casewhen type=1then (select typename from TableaType where type=1) when type=2then (select typename from TableaType where type=2) when type=3then (select typename from TableaType where type=3) else (select typename from TableaType where type=4) end ) as TypeTmp from Tablea ================================= select*,(select typename from tableType where type=t.type) as type1 from tablea t ================================== --修改表添加主键 ALTERTABLE[tablea]WITHNOCHECKADD PRIMARYKEYCLUSTERED ( [ID] ) ON[PRIMARY] GO --修改表添加默认值和唯一约束 ALTERTABLE[tablea]WITHNOCHECKADD CONSTRAINT[DF__tableb__TypeN__6346339D]DEFAULT ('') FOR[TypeName], CONSTRAINT[DF__tableb__TypeR__643A57D6]DEFAULT ('') FOR[TypeRemark], CONSTRAINT[UQ__tablea__Type]UNIQUENONCLUSTERED ( [Type] ) ON[PRIMARY] GO --修改系表的Type字段添加外键约束到另一个表 ALTERTABLE[tablec]ADD CONSTRAINT[FK_tablec_tablea]FOREIGNKEY ( [Type] ) REFERENCES[tablea] ( [Type] ) GO