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: 
Umm, you can use the `ORDER BY` clause...

```
SELECT *
FROM rss
ORDER BY rss_date;

```
```
Select * From rss Order by rss_date ASC;

```

You can use either `ASC` or `DESC`