类似 select a.* from table a,table b where a.id = b.id
select so.name,sc.name,sp.value from sysproperties sp inner join syscolumns sc on sp.id = sc.id and sp.smallid = sc.colid left join sysobjects so on so.id = sc.id
select so.name,sc.name,sp.value from sysproperties 中的SO,SC,SP什么意思? ================== 完整的字段名应该显示为 用户名.表名.字段名
select a.* from table a,table b where a.id = b.id
select so.name,sc.name,sp.value from sysproperties sp
inner join syscolumns sc
on sp.id = sc.id and sp.smallid = sc.colid
left join sysobjects so
on so.id = sc.id
中的SO,SC,SP什么意思?
==================
完整的字段名应该显示为 用户名.表名.字段名