Table Expressions are sub-queries where a table is expected. There are two types of table expressions. This post explains how to use the Table expressions and their advantages.
Derived tables
Common Table Expressions
SQL server Joins or Subqueries?
Select statements that use join operator and join statements can be written in Subqueries and similarly Subqueries can be written in Joins. Writing the Select statements with Join operator can help database engine to find more efficient strategy for retrieving the appropriate data. However each having their own advantage over other. Some problems can be easily solve with Subqueries and some can...
SQL Server Reports Integration with SharePoint 2007
This post explains how to Deploy the SQL server Reports to Office SharePoint Server 2007. SQL Server Reporting Services can operate in two modes, either in Native Mode or Share Point Integration Mode.
Report Builder 2.0 in SQL Server 2008
Report builder 2.0 is a report authoring tool that we can use to design and publish reports. We can specify the data source, what data to display on report and which layout you prefer to see the report. When you run the report, the report processor takes all the information you specified and retrieves the data and generates each page as you view it. This post explains step-by-step details of...
Joins in SQL server
Fundamentals of joins in SQL server By using joins, we can get the data from two or more tables based on logical condition between the tables. The two tables in a query related by specifying a column from each table used in the join. specifying a logical operator to be used in the comparing the columns. The following are joins by classification Inner join Outer join Left outer join Right outer...
SQL server 2005 Features
Development Features CommonTableExpressions Which returns a record set in a statement. CTE can be thought of as a temporary result set which can be defined in the SELECT,INSERT,UPDATE and DELETE statements. CTE can be self-referencing and can be referenced multiple times in the same query. The basic syntax structure for a CTE is:...