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.
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.
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.
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.
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.
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.
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.
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 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
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 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.
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.
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
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 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:
c.min and max
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.
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.
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.
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.
In this article, I will explain what is meant by cursor and types of cursor with example codes and then components which are used in cursor with syntax and Example with Explanation.How the cursor access the data inside the sqlserver.
This article gives you idea about how to do Case Sensitive search with MSSQL. Many times we need to do Case Sensitive search in database. This article will drive you through all Queries need to do Case Sensitive search. Find Case Sensitive search with SQL.
This a example to delete all stored procedures and delete all the tables from a database. Here cursor is used to fecth the consecutive objects and tables from the database. In this example you can also get an example Query for the cursor implementaition.