{{theTime}}

Search This Blog

Total Pageviews

Stored Procedure to fetch all orders created today

CREATE PROCEDURE todays_orders
AS
BEGIN
SELECT * FROM order_table where  order_date = DATEADD(DAY,-1,GETDATE())
END
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Generate Models from SQL Server using Entity Framework Core

To generate models from SQL Server database tables using Entity Framework (EF) in .NET, you can follow the Database-First approach with Ent...