73On A.Id=G.Id And A.Colid = G.Smallid
74
75Order By A.Id,A.Colorder
76
77列出SQL SERVER 所有表、字段定义，类型，长度，一个值等信息
78
79并导出到Excel 中
80
81-- ======================================================
82
83-- Export all user tables definition and one sample value
84
85-- jan-13-2003,Dr.Zhang
86
87-- ======================================================
88
89在查询分析器里运行：
90
91SET ANSI_NULLS OFF
92
93GO
94
95SET NOCOUNT ON
96
97GO
98
99
100
101SET LANGUAGE ''''Simplified Chinese''''
102
103go
104
105DECLARE @tbl 上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |
