use cms ALTER TABLE product ALTER COLUMN after_discount as ([pcost]*(1-[discount]))
Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'as'.
ALTER TABLE [product] DROP COLUMN after_discount GO ALTER TABLE [product] ADD after_discount as ([pcost]*(1-[discount]))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)