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

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

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.

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.

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.

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

In this article we will learn how to return all records if the search text is blank.

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

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

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

In this article I describe SQL Server database files.

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

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

This article presents a brief introduction to View and its impact on a .NET Application when the underlying table structure is changed.

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.

Here I will describe some useful commands in SQL.

This article provides some important tips for SQL Query Performance.

For capturing the changes of DML statements we must be familiar with the Merge statement and Output clause in SQL Server. I am giving a general overview of these statements.