代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/303209/3814520
sql getinventory.sql
SELECT InventoryId, Name, Picture, Price, InStock, DistributionCenter, Bin
FROM Inventory
www.eeworm.com/read/303209/3814521
sql createorderdetail.sql
INSERT INTO OrderDetails (OrderDetailId, OrderId, InventoryId, Quantity)
VALUES (NEWID(), @OrderId, @InventoryId, @Quantity)
www.eeworm.com/read/303209/3814522
sql updatestock.sql
UPDATE Inventory SET InStock = @InStock
WHERE InventoryId = @InventoryId
www.eeworm.com/read/303209/3814523
sql getprice.sql
SELECT Price from Inventory
WHERE InventoryId = @inventoryId
www.eeworm.com/read/303209/3814524
sql updateorder.sql
UPDATE Orders SET CustomerId = @CustomerId, DeliveryDate = @DeliveryDate, OrderState = @OrderState
WHERE OrderId = @OrderId
www.eeworm.com/read/303209/3814525
sql deleteorderdetail.sql
DELETE FROM OrderDetails WHERE OrderId = @OrderId AND OrderDetailId = @OrderDetailId
www.eeworm.com/read/303209/3814526
sql getorderdetails.sql
SELECT OrderId, OrderDetailId, InventoryId, Quantity
FROM OrderDetails
WHERE OrderId = @OrderId
www.eeworm.com/read/303209/3814527
sql gettruckload.sql
SELECT Trucks.TruckId, Trucks.LicensePlateStateProvince, Trucks.LicensePlateNumber, Trucks.RouteId
FROM Orders, Customers, Trucks
WHERE Orders.OrderId = @orderId AND
Orders.CustomerId = Cust
www.eeworm.com/read/303209/3814528
sql verifycredentials.sql
SELECT COUNT(*)
FROM Employees
WHERE UserName = @userName AND Password = @password
www.eeworm.com/read/303209/3814529
sql createorder.sql
INSERT INTO Orders
(
OrderId,
CustomerId,
DeliveryDate,
OrderState,
DisplayId
)
VALUES
(
@OrderId,
@CustomerId,
@DeliveryDate,
@OrderState,
@DisplayId
)