DevSocial Articles · SQL articles

How to configure reports on server and with ASP.NET.

This article shows a quick way to list tables with a number of rows in a database.

Emiliano MussoMar 2, 20237,8121,000

This article shows how to swap 2 column values in SQL Sever.

Rahul Kumar SaxenaMar 2, 20237,0491,000

This article shows how to use interactive sorting for a SSRS report.

Vijay PrativadiMar 2, 20237,0791,000

This article explains Case Expressions in the SQL with examples.

Pankaj Kumar ChoudharyMar 2, 202315,1031,000

This article shows you how to use a Stored Procedure for a SSRS report.

Vijay PrativadiFeb 28, 20238,3031,000

Sometimes, we want to get a common set of rows from 2 different result sets. For example, we have 2 queries, and both return employee records. If we want to find which employees are present in both result sets, then we will use INTERSECT.

In this article, I am going to explain about Certificaion of MCTS for Database Developer(70-433).

Vikrant MoreFeb 28, 20238,5771,000

This article shows how to return Coma Separated Values from a table in SQL Server.

Rahul Kumar SaxenaFeb 28, 20238,6521,000

In this section we will copy table data within the database or across two databases.

Shridhar SharmaFeb 28, 20238,6921,000

This article discusses SQL performance on optimizing SELECT Query.

GeorgeFeb 28, 202312,3471,000

In this article I explain most of the SQL Server functions for manipulating text.

Sandeep Singh ShekhawatFeb 28, 20239,6391,000

Basic considerations and examples of DATETIME, DATE and TIME data types.

Emiliano MussoFeb 28, 202310,5641,000

In this session, I will discuss SQL Like and wildcard characters in SQL Like. I will also discuss why and how to use SQL queries.

Bidyasagar MishraFeb 27, 20239,9921,000

In this article, we will see how to edit an SSRS report using SQL Server BIDS.

A constraint is nothing but a condition placed on the column or object. Let's see a small example of creating a Primary Key constraint.

Venkatesan JayakanthamFeb 27, 20239,8461,000

In this article, we have tried to help the developers choose whether to use cursors or sets.

This article explains something we sometimes need to do and maybe this will be helpful sometime.

Priti KumariFeb 27, 20239,6541,000

This article explains how to create a SQL table and how to insert, delete and retrieve data from a SQL table in Android.

Pankaj Kumar ChoudharyFeb 27, 202310,2251,000

This article will discuss Set Operators in SQL Server: UNION, UNION ALL, INTERSECT, EXCEPT.

GeorgeFeb 24, 202321,9901,000

In this article you will learn how to filter data with TOP in SQL.

Rakesh KalluriFeb 24, 202312,3651,000

Today I was given a task to convert comma-separated numbers into comma-separated weekday names in SQL.

Ahmar HusainFeb 24, 202310,4281,000

In this article I describe SQL Server database files.

Om AgarwalFeb 24, 202311,9271,000

In this article you will be learning about the basic keywords of the SQL Language.

RakeshFeb 24, 202310,0691,000

In this article we will look into how to build and debug a package in SSIS.

Karthikeyan AnbarasanFeb 23, 202316,4451,000

I happened to be working with the round function. I found some interesting/peculiar nature of the round function. Hope you will enjoy this article.

Venkatesan JayakanthamFeb 23, 20239,1431,000

Here I will describe some useful commands in SQL.

Teddy KurianFeb 23, 202310,4991,000

This article provides some important tips for SQL Query Performance.

Here the use of fishhook relation to represent tree structures is explained through a detailed example in T-SQL.