注意:非空字段不一定就是主键
---------------------------------------------------------------
select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where IS_NULLABLE='NO' and TABLE_NAME=tablename
在sql2000下测试通过
注意:非空字段不一定就是主键
---------------------------------------------------------------
select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where IS_NULLABLE='NO' and TABLE_NAME=tablename
在sql2000下测试通过