cast and convert

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  October 6, 2009 at 8:44 am

  #205303

  How can i convert this as bigint ?

  sum(size*8) as DBSize

• Mark Marinovic

  SSCrazy

  Points: 2472

  More actions

  October 6, 2009 at 8:49 am

  #1062309

  Tara-1044200 (10/6/2009)

  ---

  How can i convert this as bigint ?

  sum(size*8) as DBSize

  sum(cast(4 as bigint)*8) as DBSize

• Bradley Jacques

  Ten Centuries

  Points: 1281

  More actions

  October 6, 2009 at 9:06 am

  #1062325

  Thanks for the answer mark, here's an example with a table create and some values.

  create table TEST

  (

  size1 int

  )

  insert into test values (1)

  insert into test values (2)

  insert into test values (50)

  select sum(cast(size1 as bigint)*100) as DBSize from TEST