write formula for column in database

nedash

this is my table

Id	Price1	meter	price
1	1,000,000	250

i want when users insert data in Price1 and ,meter columns

in database automatically in Price column insert this formula

Price1*Meter

how i can write storeprocedure for this?

best regards

RkHirpar...

0 1

I think you needs to try like this.

insert into table
(
	price1,
	meter,
	price	
)
values
(
	@price1,
	@meter,
	@price1 * @meter
)

This is just logic please do required changes.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html