SQL
lambda_tea
这个作者很懒,什么都没留下…
展开
-
Oracle导出表结构
[code="SQL"] select b.TABLE_NAME as "表名", c.comments as "表说明", b.COLUMN_ID as "字段序号", b.COLUMN_NAME as "字段名", b.DATA_TYPE as "字段数据类型", b.DATA_LENGTH as "数据长度", b.DATA_PRECISION原创 2009-07-15 02:33:50 · 74 阅读 · 0 评论 -
sql server导出表结构
[code="sql"] SELECT 表名=case when a.colorder=1 then d.name else '' end, 表说明=case when a.colorder=1 then isnull(f.value,'') else '' end, 字段序号=a.colorder, 字段名=a.name, 标识=case when COLUMNPROPER...原创 2009-02-16 19:52:56 · 370 阅读 · 0 评论 -
SQL_CASE_1
表结构: ColNo Time SerialNo 1(p-key) 020111 030201 030301 AxCSAaa SceCC GYAZZ 需要: 根据SerialNo中不同的值(用空格分开)来获取Time中对应位置的值 Time格式是6个一组 [code="SQL"] selec...2009-08-07 11:50:26 · 126 阅读 · 0 评论