I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...

We have an XML schema .xsd file, and I know the structure of the XML file as well (obviously). However, I need to export data from SQL server and drop it into an XML file. The table structure would be ...

Knowing what you want from SQL Server is probably the biggest step toward running it successfully in business applications, according to consultant Koen Verbeeck. It's not just about knowing how SQL ...