Newbie Question - Data Type for Calculated Field

[Mike555]

In SQL 2000, is it possible to create a calculated table field that automatically calculates a value based on other table fields? Or must such a calculation be performed in the front-end application?

Thanks.

--
Mike

 

[JohnDTampaBay]

You can create a column field is computed based on other fields in the same table. Check out CREATE TABLE in BOL and scroll down to computed_column_expression. Examples H and I show you the T-SQL code. If you want a computed column based on values in another table, I believe you will need to use a trigger. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[Mike555]

JohnDTampaBay,

Thanks for the info. One question - What is BOL?

--
Mike

 

[SQLSister]

Books Online - the SQL Server help files.

Questions about posting. See faq183-874

 

[SQLBill]

Here's more information on BOL.

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

-SQLBill

 

[Mike555]

Thank you all very much.

--
Mike