Sql Help

• Pradeep-166220

  SSC Journeyman

  Points: 78

  More actions

  August 12, 2004 at 11:29 am

  #161308

  I have a table in sql with these field id,item,cost,quantity,total and i want that whenever some new record entered it automatically fill the toal field with value=cost*quantity or total=cost*quantity how can I do this somebody suggest me to use triggers but i don't know about triggers please help

  Thanks

• hoo-t

  SSChampion

  Points: 12713

  More actions

  August 12, 2004 at 1:15 pm

  #518751

  I would use a computed column for that.

  create table #sales

   ([id] int,

   item varchar(30),

   cost money,

   quantity int,

   total as cost * quantity)

  insert #sales

   values (1, 'widget', 1.99, 6)

  select * from #sales

  -- Steve

• Pradeep-166220

  SSC Journeyman

  Points: 78

  More actions

  August 13, 2004 at 3:09 am

  #518818

  Thanks Steve that's what i am looking for.

• Gary Andrews

  SSCommitted

  Points: 1639

  More actions

  August 13, 2004 at 8:34 pm

  #518990

  If the computed column were not the last column in the table and a table insert is performed, then must the insert specify the table column names.

  i.e. table cols are :

  id, item, cost, computed column, qty.

  Then does following insert work?

  insert tablename values (1,'widget',1.99,,6)

  Thanks

  Gary Andrews