Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
@ProdCode VARCHAR(10), @Qty INT, @RequestedBy VARCHAR(15), @Site VARCHAR(20), @WHouse VARCHAR(15), @Aisle VARCHAR(10), @Bay VARCHAR(10), @PallettNo VARCHAR(10), @InOut VARCHAR(5), @Comments VARCHAR(255) AS SET NOCOUNT ON; INSERT INTO Warehouse.Movements (ProdCode, Qty, MoveDate, RequestedBy, [Site],WHouse,Aisle,Bay, PallettNo, InOut, Comments) VALUES(@ProdCode,@Qty,GETDATE(), @RequestedBy,@Site,@WHouse,@Aisle,@Bay, @PallettNo, @InOut,@Comments) UPDATE Warehouse.Products SET Warehouse.Products.Quantity = Warehouse.Products.Quantity + @Qty WHERE Warehouse.Products.ProdCode = @Prodcode UPDATE Warehouse.Locations SET Warehouse.Locations.Qty = Warehouse.Locations.Qty + @Qty WHERE ProdCode = @ProdCode AND [Site] = @Site AND WHouse = @WHouse AND Aisle = @Aisle AND Bay = @Bay AND PallettNo = @PallettNo
|How should I architect a .NET "Interface" to accommodate database requests + database responses?||7||40|
|T-SQL: Why can you not SUM on a CASE statement, for crying out loud?||2||30|
|Sql Join Problem||2||33|
|Microsoft SQL Server 2016 Setup..error||7||32|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!