This is an example of using Excel for a front end for SQL server using Excel to validate your data. It has validation in it to notify the user of the database constraints. This whole project is solely ...

Word enables you to generate documents by creating data-driven solutions. You can create a template document that includes a custom XML part and use content controls to bind to custom XML data by ...

I have written an application that takes in a fixed-width file (thanks in no small part to advice I recieved in a seperate thread) and then dissasembles each line, runs a fairly meaty SQL SELECT query ...

Today’s author is Mike Alexander, an Excel MVP who shows us how to run a Stored Procedure to get data from a SQL server. We all know we can use MS Query to get data from a SQL server. Typically though ...

As SQL development increasingly becomes part of full-stack workflows, developers are looking for ways to simplify their tooling without compromising capability. While SQL Server Management Studio ...