zlika's

As we can read in Books Online in SQL Server
Ranking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Ranking functions are nondeterministic.
I have created simple example for usage of the Ranking function DENSE_RANK(). We have [...]

If you use Outlook 2010 and you prefer to have your data files on external hard drive, you have to point your file location as you add your account manually :-)
Félicitations

I was interested of the different SQL “accents”. According to Microsoft SQL Server learning books, we query like this:

SELECT
*

FROM
table1 INNER JOIN table2
ON table1.PK = table2.FK
GO

The MySQL guys makes queries like this:

SELECT *
FROM table1, table2
WHERE table1.PK = table2.FK;

Using Microsoft SQL Server 2008, I wrote a script to create and populate two tables [...]