2009年12月4日
取得sql2005 表字段信息的sql语句
摘要： SELECT ROW_NUMBER() OVER (ORDER BY id) AS ROW_NUMBER, FieldName, fieldDescn AS cnName, FieldType, fieldLength, isIdentifier, iskeyField, allowNull, defaultValue,fieldDescnFROM (SELECT TOP 100 a.id, d .name N'TableName', a.colorder N'FieldNumber', a.name N'FieldName', (CASE WHEN COLUMNPROPERTY(a. 阅读全文
posted @ 2009-12-04 14:35 ljlxyf 阅读(190) 评论(0) 推荐(0)