how to calculate in sql server 2008 online web admin?

[mayapple]

hi guys,

now I have a SQL Server Web Admin, and I use ODBC for access to connect with it.

I have a table: TABLE1

in TABLE1 I have 3 columns: A B C

I will input A B by myself, and I want C=A*B automatically

I can't find out how to change expression of C in the web admin, is there any other way to realize that?

many thx!

Jackie

 

[mdlueck]

I will input A B by myself, and I want C=A*B automatically

So any time either ColA or ColB changes you want ColC automatically recalculated?

If so, sounds like you will need a Trigger:

"CREATE TRIGGER (Transact-SQL)"
http://technet.microsoft.com/en-us/library/ms189799.aspx

"An Introduction to Triggers -- Part I"
http://www.sqlteam.com/article/an-introduction-to-triggers-part-i

 

[mayapple]

cool, it helps! it's okay now, thx!

So any time either ColA or ColB changes you want ColC automatically recalculated?

If so, sounds like you will need a Trigger:

 

[SQL_Hell]

Hi,

This could have been done better using a computed column rather than a trigger

http://www.mssqltips.com/sqlservert...-columns-in-sql-server-with-persisted-values/

 

[mayapple]

yes that will be better if there's a computed column function, I thought there's no such kind of function in sql server.

but in my godaddy web admin, I can't find how to modify the column as calculated column, maybe can be modified only by code.

thx a lot!



-------------
This could have been done better using a computed column rather than a trigger

 

[SQL_Hell]

Why don't you use SQL Server management studio rather than this Godaddy thing?