04 2010 档案

model 和WEB前台页面提交完美自动填充
摘要:为提高开发效果,欢迎大家查看,下载或完善修改。 阅读全文

posted @ 2010-04-08 14:57 heshangwen 阅读(647) 评论(0) 推荐(0)

sql 2005 跟据视图名列出视图所有列的描述
摘要:select vcu.view_name,tbd.* from (select tmp.tablename,tmp.columnname,ep.* from sys.extended_properties ep join (select tb.name as tablename, cl.object_id,cl.name as columnname,cl.column_id from sys.co... 阅读全文

posted @ 2010-04-02 13:48 heshangwen 阅读(918) 评论(0) 推荐(0)

sql 2005 返回列描述的SQL语句
摘要:select tmp.tablename,ep.* from sys.extended_properties ep join (select tb.name as tablename, cl.object_id,cl.name as columnname,cl.column_id from sys.columns cl join(select name,object_id from sys.tab... 阅读全文

posted @ 2010-04-02 09:47 heshangwen 阅读(856) 评论(0) 推荐(0)