摘要：SELECT表名=case when a.colorder=1 then d.name else '' end,表说明=case when a.colorder=1 then isnull(f.value,'') else '' end,字段序号=a.colorder,字段名=a.name,标识=case when COLUMNPROPERTY(a.id,a.name,'IsIdentity')=... 阅读全文

摘要：select distinct A.ID from A where A.ID not in (select ID from B) select A.ID from A left join B on A.ID=B.ID where B.ID is null select * from B where (select count(1) as num from A where A.ID = ... 阅读全文

摘要：在网上看一些，以及我个人使用的方法，总结一个规则：table1_table2 阅读全文

摘要：SELECT 32-DAY(getdate()+32-DAY(getdate())) 阅读全文