SQL 2008 r2 database design question

[wbodger]

I am working on a db design for a client, taking data from an Excel file and creating tables. There are a couple of places where the field is a 'calculated' field, it combines six fields to make a barcode. How would you create this field to auto-fill when the record is entered?

 

[SQLScholar]

Use a computed column.

http://msdn.microsoft.com/en-us/library/ms191250(v=sql.105).aspx

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[wbodger]

Cool, thanks!