订阅
上一篇
下一篇
笔记：查询表的字段、类型和注释等信息
作者:随风 日期:2008-10-15 20:39:27
insert into SF_AdvancedSearchSetting
(TableName,FieldName,FieldNameText,FieldValueType,FiledEnumType,IsConditionField,IsOrderField,IsDefaultSelectField,Description)
select 'sjzl',COLUMN_NAME,CONVERT(nvarchar(50),[value]),DATA_TYPE,null,1,0,1,CONVERT(nvarchar(256),[value]) from (Select a.id,a.smallid, a.[value],
b.COLUMN_NAME,DATA_TYPE ,b.ORDINAL_POSITION
FROM sysproperties as a RIGHT OUTER join INFORMATION_SCHEMA.COLUMNS as b on a.smallid=b.ORDINAL_POSITION
where a.[id] = (select [id] from sysobjects where [name] = 'clzl' )
and (b.TABLE_CATALOG = 'taxi')
and (b.TABLE_NAME = 'clzl')
) as [temp]
实际中用的的一个语句，没有整理
查询clzl表的字段信息，并将一些信息插入到一个新的表中。
(TableName,FieldName,FieldNameText,FieldValueType,FiledEnumType,IsConditionField,IsOrderField,IsDefaultSelectField,Description)
select 'sjzl',COLUMN_NAME,CONVERT(nvarchar(50),[value]),DATA_TYPE,null,1,0,1,CONVERT(nvarchar(256),[value]) from (Select a.id,a.smallid, a.[value],
b.COLUMN_NAME,DATA_TYPE ,b.ORDINAL_POSITION
FROM sysproperties as a RIGHT OUTER join INFORMATION_SCHEMA.COLUMNS as b on a.smallid=b.ORDINAL_POSITION
where a.[id] = (select [id] from sysobjects where [name] = 'clzl' )
and (b.TABLE_CATALOG = 'taxi')
and (b.TABLE_NAME = 'clzl')
) as [temp]
实际中用的的一个语句，没有整理
查询clzl表的字段信息，并将一些信息插入到一个新的表中。
文章来自: 
引用通告地址: 
Tags: 评论: 0 | 引用: 0 | 查看次数: 879
发表评论