Devart Forums

Which is the better way to retrive TOTAL value ( calculated field in SQL SERVER 2005 or greater)?


CREATE TABLE [dbo].[testcalc] (
[NUMBER] int IDENTITY(1,1) NOT NULL ,
[QTY] int NULL ,
[VALUE] decimal(12,2) NULL ,
[TOTAL] AS QTY * VALUE PERSISTED ,
PRIMARY KEY ([NUMBER])
)
GO

Thanks for helping

Please describe in more details the case, when you want to use calculated fields of SQL Server in UniDAC. If you have a small test sample for such case, please send it to andreyz*devart*com .