呵呵,我来试试,如果答出来了多给点分就行。 1、获取一个表的某字段是否为空: select col_name(o.id,c.colid) as colname,c.isnullable from sysobjects o,syscolumns c where o.name='表名' and o.id=c.id and c.colname='列名' 2、得到主键目前只能得到主键名: SELECT * FROM sysobjects WHERE (parent_obj = (SELECT id FROM sysobjects WHERE (name = 'r_subject'))) and xtype='pk' 得到哪个字段是主键后别忘记告诉我。 3、索引字段类同于2
1、获取一个表的某字段是否为空:
select col_name(o.id,c.colid) as colname,c.isnullable from sysobjects o,syscolumns c where o.name='表名' and o.id=c.id
and c.colname='列名'
2、得到主键目前只能得到主键名:
SELECT *
FROM sysobjects
WHERE (parent_obj =
(SELECT id
FROM sysobjects
WHERE (name = 'r_subject'))) and xtype='pk'
得到哪个字段是主键后别忘记告诉我。
3、索引字段类同于2