Mssql查询表中是否包含某名称字段
sql语句如下:
select [name] from [UFTData548530_001002].[dbo].sysobjects
where id in(select id from [UFTData548530_001002].[dbo].syscolumns Where name='origPrice')
学以致用,只争朝夕,不负韶华。
sql语句如下:
select [name] from [UFTData548530_001002].[dbo].sysobjects
where id in(select id from [UFTData548530_001002].[dbo].syscolumns Where name='origPrice')