SQL Decimal

Why SQL Decimal is important

-- Create a sample table
CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    CustomerID INT,
    OrderTotal DECIMAL(10, 2)
);

-- Insert some sample data
INSERT INTO Orders (OrderID, CustomerID, OrderTotal)
VALUES
(1, 101, 150.00),
(2, 102, 25.50),
(3, 101, 500.00),
(4, 103, 10.00);

-- Declare a cursor to iterate through the Orders table
DECLARE OrderCursor CURSOR FOR
SELECT OrderID, CustomerID, OrderTotal
FROM Orders
WHERE OrderTotal > 100;

-- Declare a variable to hold the OrderID
DECLARE @OrderID INT;

-- Declare a variable to hold the CustomerID
DECLARE @CustomerID INT;

-- Declare a variable to hold the OrderTotal
DECLARE @OrderTotal DECIMAL(10, 2);

-- Open the cursor
OPEN OrderCursor;

-- Fetch the first row
FETCH NEXT FROM OrderCursor INTO @OrderID, @CustomerID, @OrderTotal;

-- Loop through the rows
WHILE @@FETCH_STATUS = 0
BEGIN
    -- Check if the order total is greater than 100
    IF @OrderTotal > 200
    BEGIN
        -- Update the customer's address (replace with your actual update)
        UPDATE Customers
        SET Address = 'New Address'
        WHERE CustomerID = @CustomerID;
        PRINT 'Updated customer ' + CAST(@CustomerID AS VARCHAR(10)) + ' with new address.';
    END
    -- Fetch the next row
    FETCH NEXT FROM OrderCursor INTO @OrderID, @CustomerID, @OrderTotal;
END;

-- Close the cursor
CLOSE OrderCursor;

-- Deallocate the cursor
DEALLOCATE OrderCursor;