SQL Server Data Validation Introduction
This post is about validating data in a single table. We have gathered data from the Internet and […]
Database
SQL Server Aggregate Window Functions
Aggregate window functions in SQL Server are similar to grouped functions (SUM, AVG and so on) except that […]
SQL Server Window Functions
Window functions are used in SQL Server to perform data-analysis calculations. A data-analysis calculation is one you apply […]
SQL Server Collation
Collation is not a simple topic in SQL Server. There is an article written by Robert Sheldon called […]
SQL Server Import Data from a Text File Part 4
This part of our multi-part series discusses BULK INSERT. Here we focus in on this command. Microsoft’s Books […]
SQL Server Order By For XML
This post considers a couple of SQL Server statements: Order By and For Xml. If you have a […]
SQL Server Insert Into Select Part 1
This post discusses how to insert data from one table into another existing table. The second table must […]
SQL Server Like Predicate
Before discussing LIKE, we will define what a predicate is. The term “predicate” is used to refer to […]
SQL Server Table Expressions
What is a table expression? Table expressions are named query expressions that represent a valid relational table. Table […]
SQL Server Apply
SQL Server 2005 introduced the APPLY operator, which is very much like a join clause. APPLY allows the […]
SQL Server Error 15517
There is a good article at SQLServerCentral.com that helps you troubleshoot this error 15517 on SQL Server. I […]
SQL Server Logical Query Example
This post is a continuation of the post called SQL Server Logical Query. It is based on the […]