bierid aantal prijs 1 5 2 2 0 2 NULL NULL NULL CREATE TABLE [dbo].[Bier] ( [BierId] INT IDENTITY (1, 1) NOT NULL, [Aantal_consumpties] INT NULL , [Prijs] INT NOT NULL, PRIMARY KEY CLUSTERED ([BierId] ASC)
select sum(Aantal_consumpties * Prijs) AS prijsbier FROM Bier
UPDATE Bier SET Aantal_consumpties = 5; select sum(Aantal_consumpties * Prijs) AS prijsbier FROM Bier;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)