SQL Server



You can make money from this site by posting original and quality articles that comply with Google AdSense policies.. Also, we offer several other reward programs including monthly profit sharing, cash rewards per post, contests & prizes etc to contributing members.

Submit Your Article

Articles

DELETE and UPDATE based on JOIN

This article outlines what is DELETE and UPDATE based on JOIN operations. How to use DELETE based on join operation; and similarly how to use UPDATE based on join operation. Both syntax are not SQL standard syntax.

Using Table-valued parameters in SQL Server

This article outlines what is Table-valued parameter; how to use table-valued parameter in Stored Procedure; How to pass table-valued parameter fro client application; and restriction on the table-valued parameter.

SQL Server - Sub Queries

Subquery or Inner query or Nested query is a query in a query. SQL subquery is usually added in the WHERE Clause of the SQL statement. Most of the time, a subquery is used when you know how to search for a value using a SELECT statement, but do not know the exact value in the database.

SQL – Pivot - Unpivot, Dynamic Pivot Concepts

In this article, we will understand the PIVOT and UnPivot Concept in SQL Server. We will discuss the scenario when we need to understand and use Dynamic PIVOT Concept in SQL. PIVOT concept is used to summerize the data using SQL Query. Lets understand the concept in brief.

SSIS – Generate dynamic flat files using Variables and Expressions

In this article we will learn how to generate dynamic flat files in SSIS. Using Variables and Expressions, we can generate dynamic Flat files in a particular format. We can use this concept when there is a requirement of generating files in a regular interval without overwriting the existing files. Lets understand the requirement and its solution.

Merge Join Transmission in SSIS

In this article, I create a simple ETL package that join the data from two SQL tables using merge join transmission and finally loads the result into a SQL table.Merge Join is same as JOIN in t-sql, you can choose between different types of Inner join, Left outer join and Full outer join.

Grouping in SSRS Reports

In this article, I have explained how to create a grouped reports in SSRS. Groups are created to organize data on the report or to calculate aggregate summaries. An understanding how to define groups and use group features helps you design reports that are more concise and communicate summarized data in a more compact format.

SSIS - Import MS Excel Worksheet data into a Database

This article will help you to understand that how to import the Excel worksheet data into database using data conversion function. Data Conversion is used to change the data type of a column. Let say we have Unicode String format in Source database and the same column is defined as Non Unicode in destination. In this case we need to convert the data. This is the case when data conversion is used.

SSIS – Fuzzy LookUp Transformation

This article will help you to understand the concept of data cleaning task such as removing dirty data, correcting the data etc. This can be achieved by using functions like SORT, Fuzzy Lookup,condition split,union all.

SSIS – Merge Join Transformation

This article will help you to understand the concept of retrieving and merging the data from different sources and generate output file in SSIS. This will help us to merge the data from different data sources and generate output as per the requirement. We have two data sources like OLE DB source (SQL Database) and Excel Source. Using functions like SORT, Merge Join, We will merge the data and generate the flat file as output. Let's understand how we can achieve this requirement using SSIS

SQL Server Set operators

SQL set operators allows combine results from two or more SELECT statements. At first sight this looks similar to SQL joins although there is big difference. SQL joins tends to combine columns i.e. with each additionally joined table it is possible to select more and more columns. SQL set operators on the other hand combine rows from different queries with strong preconditions

Group by – grouping sets, roll up & cube

This article discusses Grouping Sets in T-SQL. Grouping Sets is a new feature in T-SQL in SQL Server 2008.The ROLLUP, CUBE, and GROUPING SETS operators are extensions of the GROUP BY clause.By using GROUPING SETS() we can specify multiple groupings in a single query. GROUPING SETS() generates the result by producing a UNION ALL set of the result sets generated by specified grouping sets.

SQL Server Ranking Functions

SQL Server introduced four new ranking functions either to rank records in a result-set or to rank records within groups of records of a result-set. 1.ROW_NUMBER () 2.RANK () 3.DENSE_RANK () 4.NTILE ()

Table expressions in t-SQL

This article outlines the different Table Expressions available in T-sql, how to define them and how to use them in queries: derived tables, common table expressions, views, inline table-valued functions.

Debug your stored procedure

In this article i have explained how to debug your stored procedure with the digramatic representation. Many developer unaware of debugging in Stored Procedure with the help of visual studio SQL server addins, this article really helpful for them

Aggregate Functions in Sql Server

In this article, I explain the purpose of using Aggregate Functions with relevant Examples. Some of Aggregate Functions explained are AVG; CHECKSUM_AGG; COUNT; COUNT_BIG; GROUPING; MAX; MIN; SUM; STDEV; STDEVP; VAR; VARP;

Aggregate functions in SQL

Aggregate functions: Aggregate functions are the only functions in SQL which ignore the NULL values by default. These are the built-in functions in SQL. There are five types of aggregate functions in SQL which are listed below: a.avg b.sum c.min and max d.count

Types of joins in sql server

In this article i explain about joins in sql server. Join is used to combine two or more tables with common relationship between tables. There are various types of joins like inner join, outer join, cross join in sql server. If we want to select data from two different tables we can use these joins.

Sql Join Understanding

by reading this content you can come to know how join is working in sql to get output faster and safer.

How to Rename Database or Table or Column in two ways

The article gives you detailed information with screen shots about renaming a Database, Table and Column in two ways. One way is using Sql Server Management Studio, with this you can rename easily. The other way is using SQL command, but for this you need to remember SQL Command syntax for renaming.

What is SET NOCOUNT ON in SQL Server?

By using SET NOCOUNT ON in Sql Server Stored Procedure the number of rows affected by the Sql Statements will not be returned. It will increase the overall performance of the database. By giving command SET NOCOUNT OFF the number of affected rows will again returned.

Date Convert function in SQL Server 2008.

In this article I will Explain date convert functions which are available in SQL Server 2008 and its definition then difference between Convert funtion and cast function in sql server.Syntax and Example for Convert and Cast function.Different Styles of date format by using Convert function.Advantages of using Convert Function in Sql Server.

Submit Your Article