摘要：以前总用where，但面对遗留系统里有很多这种sql的时候，要理解它做什么，就不得不去看join了aid,aname,bid----------------1,one,13,three,3bid,bname---------------1,b12,b2join类型:1.join,inner joininner join=join=where.....e.g:select * from [a] in... 阅读全文

摘要：Sql Server版：列出当前DB中所有表：select name from dbo.sysobjects where xtype='u' and (not name LIKE 'dtproperties')列出表中所有字段：SELECT dbo.sysobjects.name as Table_name, dbo.syscolumns.name AS Column_nameFROM dbo.s... 阅读全文

摘要：select name 列 from syscolumns where id=object_id('表名') ＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝ select name 列 from syscolumns where id=object_id('表名') --数目... 阅读全文