Question: I need to bulk load huge xml files to SQL Server 2005. I decided to use SQLXMLBULKLOAD in my C# app, but I need to get valid xsd-schemas of those xml files to load them. Which is best way to generate xsd file?
I tried MS VS xsd.exe, but it tries to load the file into memory, which causes OutOfMemory exception.

Thanks!

Answer: 
You can use `ORDER BY` with `ASCENDING` or `DESCENDING`.

If you want to show in ascending order it is not necessary to put `ASC`. For `DESCENDING`you have to use `DESC` after the column name.

For example:

```
SELECT *
FROM tableName
ORDER BY columnName DESC; -- or ASC;

```
Umm, you can use the `ORDER BY` clause...

```
SELECT *
FROM rss
ORDER BY rss_date;

```