List: SQL-Eng | Curated by Onur Karaoz | Medium

Jan 29, 2025

5 stories

SQL-Eng

Onur Karaoz

Changing Table and Object SCHEMA in SQL Server

In SQL Server (MSSQL), you can change the schema of a table using the ALTER SCHEMA command. This command allows you to transfer a table to…

Jan 29

Jan 29

Onur Karaoz

What is a SQL Server Stored Procedure and How to Use It?

In SQL Server, Stored Procedures are database objects used to simplify repetitive operations, improve performance, and prevent code…

Jan 3

What is a SQL Server Stored Procedure and How to Use It?

Jan 3

Onur Karaoz

Automated SQL Script Execution and Database Setup

First, a connection string is created to connect to the database. The BaglantiOlustur function performs the following steps to create a…

Jan 1

Jan 1

Onur Karaoz

SQL ORDER BY Usage (Sorting)

In SQL, the ORDER BY statement is used to sort the query results based on a specific column or columns. By default, it sorts in ascending…

Dec 28, 2024

Dec 28, 2024

Onur Karaoz

Deleting Duplicate Records in SQL

In SQL, the “DISTINCT” keyword can be used to remove duplicates from the result of a query. It ensures that only unique records are…

Dec 27, 2024

Dec 27, 2024

Onur Karaoz

Onur Karaoz

As a .NET Developer, I have experience in JavaScript, ASP.NET Core, and API development. I also share my knowledge and experiences in the software world.

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams