sql查询是否存在字段 select a.name from syscolumns a inner join sysobjects b on a.id=b.id where b.name=@TableName and a.name=@fieldKey 删除字段 ALTER TABLE tablename DROP columnName
delete from a where ID in( select ID from a left join b on a.Name=b.Name where b.Name is null )
delete from tab1 where exists(select 1 from tab2 where name=tab1.name)
查找是否在字段 select a.name from syscolumns a inner join sysobjects b on a.id=b.id where b.name=@TableName and a.name=@fieldKey 删除字段 ALTER TABLE tablename DROP columnName
语法如下: DELETE FROM A WHERE A.ID IN ( SELECT A.ID FROM A,B WHERE A.ID<>B.ID )
select a.name from syscolumns a inner join sysobjects b on a.id=b.id where b.name=@TableName and a.name=@fieldKey
删除字段
ALTER TABLE tablename DROP columnName
where ID in(
select ID from a
left join b on a.Name=b.Name
where b.Name is null
)
delete from tab1 where exists(select 1 from tab2 where name=tab1.name)
select a.name from syscolumns a inner join sysobjects b on a.id=b.id where b.name=@TableName and a.name=@fieldKey
删除字段
ALTER TABLE tablename DROP columnName
DELETE FROM A
WHERE A.ID IN (
SELECT A.ID
FROM A,B
WHERE A.ID<>B.ID
)
另外 用exists 代替 in not in