DevSocial Articles · SQL articles

In this article, you will learn how to use a SQL SELECT-GROUP BY statement in SQL.

Naresh BeniwalJan 16, 202367,1801,000

How to use a database to find nearby locations. The geography data type and associated SQL Server functions can be used to calculate distances and search for nearby locations.

Andrew FensterJan 16, 202345,4831,000

Change tracking captures rows in a table that have been changed, but do not capture the data that was changed.

Jignesh TrivediJan 16, 202356,2621,000

Microsoft SQL Server Compact Edition is an embedded database system that allows us to integrate it in our Web, Desktop and Mobile applications.

Abhimanyu K VatsaJan 16, 202344,2651,000

In SQL Server 2005 and later version of it, database objects like function, store Procedure, etc can be created which are already created in CLR.

Jignesh TrivediJan 14, 202316,9971,000

In SQL Server 2005 and later versions of it, database objects such as functions, Stored Procedures, etc. can be created which are already created in CLR.

Jignesh TrivediJan 14, 202349,8841,000

In the article, I will cover how to use table variable techniques in order to simulate the autonomous transaction behavior of Oracle databases in Microsoft SQL Server.

John Charles OlamendyJan 14, 202353,2301,000

In this article, I will explain steps need to send emails from SQL Server.

Extended Properties in SQL Server allows us to create additional customized properties to store additional information. Extended Properties are a way to create a self-documenting database.

Jignesh TrivediJan 12, 202365,5941,000

This article explains how to convert one type of data into another then again repeat the procedure for converting that type of data into another form.

Abhishek JaiswalJan 12, 202357,7001,000

This article explains database tracking in SQL using TFS.

Akhil GargJan 12, 202354,3151,000

In this article, I describe Views in SQL Server. Views are database objects which are like virtual tables that have no physical storage and contains data from one table or multiple tables.

Deepak MiddhaJan 12, 202365,6681,000

In this article you will learn how to make Equated Monthly Installments (EMIs) for a loan in SQL Server.

Shubham KumarJan 12, 202359,9051,000

In this article I provide a quick overview of how to use the right and left functions in SQL Server.

Rohatash KumarJan 12, 202362,3621,000

In this post I would like to share something regarding Entity Framework, how we can implement CRUD operations using stored procedures in Entity Framework.

Dorababu MekaJan 11, 202363,4621,000

SQL REPLACE function inserts or replaces values of records in a database table. This article will teach you how to use a Replace in SQL.

Naresh BeniwalJan 10, 2023106,6831,000

SQL Server Compact Edition (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops.

Nipun TomarJan 10, 2023131,0311,000

In this article I will explain reading XML data from XML String \ XML File through SQL Stored Procedure.

Vivek SrivastavaJan 10, 202391,3511,000

Here I am going to discuss deleting files using SQL Job.

Hemant SrivastavaJan 10, 202397,5121,000

This article will discuss alternative methods for performing cascading deletes using LINQ to SQL. Cascading delete refers to the action of removing records associated by a foreign key relationship to a record that is the target of a deletion action.

Scott LysleJan 10, 202370,8221,000

In this article you will learn how to Implement UPSERT () Method in C#.

Balakrushna SwainJan 9, 202373,7131,000

In this article, we will discuss the concept of Inserted and Deleted tables in SQL.

Jasminder SinghJan 9, 202385,7631,000

In this article you will learn about SQL Data Types in detail.

Mahesh AlleJan 9, 202387,3911,000

SPARSE column is ordinary type column that has an optimized storage for NULL values.

Jignesh TrivediJan 9, 202378,1691,000

This article will discuss 11 important database designing rules.

ShivprasadJan 6, 202374,3191,000

This article shows how to use a SQL query to perform searching, sorting and paging by one query.

In this article series, we will understand a few important concepts to develop projects in SQL Server CLR. Please don't be confused by the name SQL-CLR, It's nothing but a SQL Server CLR project. For the sake of simplicity, in this article we will call it SQL-CLR.

Sourav KayalJan 5, 202380,4951,000

In this article I will briefly describe a subquery vs a correlated subquery in SQL.

Jasminder SinghJan 5, 202388,9771,000

I have reviewed and answered many articles related to SQL Server. For the previous one and a half months, I found 3 to 4 articles related to finding comma separated values in SQL Server. So I decided to write an article on Comma Separated Values in SQL, it might help people who are looking for a solution of this.

Jignesh TrivediJan 4, 2023149,4791,000