if exists(select 1 from syscolumns where id=object_id('表名') and name='def') select '在' else select '不在'
select * from syscolumns where id = object_id(N‘tablename') and name = 'def')
你是想判断def这个值,是否在 def chinese english 这几个列中吧?用下面的语句:if exists(select 1 from 表 where def='def' or chinese='def' or english='def') print '在' else print '不在'
if exists(select name from syscolumns where id=object_id('tablename'))
print 'exist'
else
print 'no exist'
列名写好后能改吗?
如何改?exec sp_rename 'you_table.field1','field2'
select '在'
else
select '不在'
print '在'
else
print '不在'
这里几本SQL书都不错.