how do i create a scalar valued functionto get the total cost of the UnitCost in the ProductsTable
how do i create a scalar valued functionto get the total cost of the UnitCost in the ProductsTable
Create table Products(
ProductID int primary key,
CategoryID varchar (200),
MobileNumber varchar(200),
ModelName varchar (200),
ProductImage varchar (200),
UnitCost varchar (200),
Description varchar (200),
);
insert into Products(ProductID,CategoryID,MobileNumber,ModelName,ProductImage,UnitCost,Description)
values(1000,'011','1-758-914-0628','RobotDestroyer','Robot Image','R79.60','The new RobotDestroyer defender of the universe')
insert into Products(ProductID,CategoryID,MobileNumber,ModelName,ProductImage,UnitCost,Description)
values(2000,'012','(701) 754-5550','GardenSpade','GardenSpadeImage','R50.90','Guaranteed to get the toughest weeds out')
insert into Products(ProductID,CategoryID,MobileNumber,ModelName,ProductImage,UnitCost,Description)
values(3000,'013','(723) 280-3358','Broom','Broom Image','R78.92','The best broom you will ever need with new ergonomic handle')
insert into Products(ProductID,CategoryID,MobileNumber,ModelName,ProductImage,UnitCost,Description)
values(4000,'014','1-253-358-4831','Barbie Doll','Barbie Image','R53.20','Perfect present for any girl with an imagination')
insert into Products(ProductID,CategoryID,MobileNumber,ModelName,ProductImage,UnitCost,Description)
values(5000,'015','(819) 786-7127','ToiletBrush','ToiletBrush Image','R43.11','This brush gets the job done fast')
Step by step
Solved in 2 steps
