Kas saaksite anda SQL-päringute näiteid, mida olete loonud andmebaasiga töötamiseks?

Here are some examples of SQL queries I have created in C# projects for working with databases:

1. Data selection:

SELECT Id, Name, Email FROM Users WHERE IsActive = 1 ORDER BY Name

2. Inserting a new record:

INSERT INTO Products (Name, Price, Quantity) VALUES ('Notebook', 1200.50, 10)

3. Updating data:

UPDATE Orders SET Status = 'Shipped' WHERE OrderId = 12345

4. Deleting a record:

DELETE FROM Sessions WHERE LastAccess < '2024-01-01'

In C#, I usually use parameterized queries with ADO.NET or ORM (e.g., Entity Framework) for security and convenience.