Advertisement
Guest User

Untitled

a guest
Dec 11th, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1.  
  2. select a.name as EsmTable, sum( b.max_length) * (select count(*) from [dbo].[Afi1FDocB] where SerialNumber = 1) as tulRecord
  3. from sys.tables a inner join sys.columns b
  4. on(b.object_id = object_id(a.name))
  5. where a.name = 'Afi1FDocB'
  6. group by a.name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement