Sql

有时忘记某个字段在数据库中的哪个表里了，可以利用syscolumns来进行查找。 select object_name(id) objName,Name as colName from syscolumns where (name like'%模糊被查找字段%') and id in(select id from sysobjects where xtype='u') order by objname;

INNER JOIN 关键字在表中存在至少一个匹配时返回行。如果表中没有匹配，则不会列出这些行。 SELECT a.AAA,b.BBB,c.CCC,d.DDD,a.MT,a.AAB,a.AAC,a.AAD,f.FFF FROM tableA AS a INNER JOIN tableB AS b ON b.B_AAA = a.AAA INNER JOIN tableC AS c ON c.CCD = a.AAD INNER JOIN tableD AS d ON d.DDE = a.AAE INNER JOIN tableE AS e ON e.EEF = a.AAF INNER JOIN tableF AS f ON f.FFG = e.EEG WHERE a.AAA IN (XXX,YYY,ZZZ);