Learn it from developers who built it.
Tutorials, how-tos and deep dives on AI, .NET, C#, cloud and developer tools, written by the community.
How to use Cursor and XML together in SQL Stored Procedures.

Learn how to create SQL Server computed columns with CREATE TABLE and ALTER TABLE, compare persisted and non-persisted columns, and understand their limitations.

In this article, you will learn about Computed Columns in SQL Server.

In this article, we will read about XML data type and also some advantages and limitations of XML data type over relational data types.

A SQL Server Index is used on a database table for faster data access. In this article, learn what SQL Server Indexes are, why do we need them, and how to implement Indexes in SQL Server.

In this article, you will learn about dynamic SQL query injection and its prevention mechanism.

A system-versioned temporal table is a type of table in SQL Server that automatically tracks the historical changes to the data in the table

This article let us know, how to delete a column that has a default constraint in SQL server.

In SQL, Today's date can be used in SELECT, INSERT, and UPDATE statements. It can also be used in conjunction with other functions and operators for calculations or comparisons. Additionally, today's date can be used for efficient manipulation and retrieval of date-related data within a SQL database.

This article shows how to insert and update in SQL Server using user-defined table type and XML.

Retrieve a collection of SQL Server databases and a specific database by name in C# using SQL Server Management Objects and a connection string.

This article explains various types of SQL Server commands, like DDL, DCL, DML, and TCL etc.

In this article, we will see how to use the cast and convert functions in SQL Server 2012.

In this article, you will learn about the SQL SERVER MERGE statement.

In this article, you will learn how to send email from SQL Server database.

Learn the main types of SQL Server joins, including inner, left, right, full, self, and cross joins, with syntax and examples.

Learn how to use SQL Server ranking functions including ROW_NUMBER, RANK, DENSE_RANK, and NTILE with ORDER BY and PARTITION BY examples.

SQL (Structured Query Language) is a language to access RDBMS. Here is a list of most popular SQL interview questions and answers.

This article explains multiple grouping sets in SQL Server.

In this article, you will learn how to move data from Excel file to SQL Server table using SSIS.

This article will give you an idea of how to use SQL Cascading Constraint and also defines the situations where you can use it.

In this article, we will learn how to find and delete duplicate values from a table in SQL Server.

Learn what is a Table Valued Parameter in SQL Server and how to create and use table valued parameters in stored procedures and queries.

In this article, we will create a Stored Procedure in SQL Server that fetches data from tables and performs operations like searching, sorting, and pagination based on parameters passed in that stored procedure and return data.

In this article you will learn how to create, alter, and drop tables in SQL.

In this article, you will learn how to Install SQL Server Management Studio 2019.

This article describes how to read data from a JSON string

In this article, you will learn how to optimize SQL Query.

In this article you will learn, how to create a report using report wizard in SSRS.
Everything on SQL Server, not only its articles: the SQL Server page →
DevSocialUpcoming · 3rd editionAI Agents ConferenceNov 23–27, 2026Live onlineMembers only16days leftRegisterMembers onlyWrite an article and earn +1,000 SHARP when it is approved.
Write an article