Advertisement
Guest User

Untitled

a guest
Aug 4th, 2015
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. declare @dbs table
  2. (
  3. name varchar(200),
  4. [size] varchar(20),
  5. owner varchar(50),
  6. dbid int,
  7. created datetime,
  8. status varchar(4000),
  9. compat int
  10. )
  11. insert into @dbs exec sp_helpdb
  12.  
  13. select name,
  14. substring(size, 1, len(size) - 3) as size
  15. from @dbs
  16. order by
  17. name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement