nvarchar(200),@fld nvarchar(200),@sql nvarchar(4000),@maxlen int,@sample nvarchar(40)
106
107
108
109SELECT d.name TableName,a.name FieldName,b.name TypeName,a.length Length,a.isnullable IS_NULL INTO #t
110
111FROM syscolumns a, systypes b,sysobjects d
112
113WHERE a.xtype=b.xusertype and a.id=d.id and d.xtype=''''U''''
114
115
116
117DECLARE read_cursor CURSOR
118
119FOR SELECT TableName,FieldName FROM #t
120
121
122
123SELECT TOP 1 ''''_TableName '''' TableName,
124
125 ''''FieldName '''' FieldName,''''TypeName '''' TypeName,
126
127 ''''Length'''' Length,''''IS_NULL'''' IS_NULL,
128上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |
