Alter Procedure getDatabaseInfo9 asselect (Case When B.colorder = 1 or B.colorder is null damaseinfo9 asselect) AS N 'Name', B.NAME AS N 'Field Name, C.Name As n' Data Type ', B.PREC AS N' Length ', (Case When B.colstat = 4 Then' √'lse '' End) N 'Whether Output', B.ColORDER N 'Field Series' (Case When B). Colorder = 1 or b.colorder is Null Then D.Text else '' end) AS N 'content' from sysobjects a left join syscolumns b on b. ID = A.ID Left Join Systypes c on (C.XTYPE = B. Xtype and c.name <> 'sysname') Left Join SysComments D on D.Id = a.id where a.schema_ver = 0 and a.xtype = 'p' Order by a.name, b.colorder return - by Huntfox
