FixedThe basics of SQL are easy.
Fixed
And that's only really true if the data is set up correctly in the first place.... If the database structure is badly designed (and that's far more common than it should be), the SQL can quickly go from easy to WTF???
If I wanted to knock together some C# prog that interfaced with a database would SQL Server 2008 Express be OK for me? Would I be able to use VS2008 to get the C# program to work with the SQL Serer 2008 Express?You might want to steer clear of trying SQL within access; it makes it extremely frustrating.
Personally I'd grab a copy of Microsoft's SQL Server 2008 Express - it's free and comes with Management Studio which is a great management program to interface with the database.
Nice.Yep, they both work perfectly well together. Infact we use Visual Studio 2008/C# and the express edition on our server at work. We don't need the features of the more expensive packages right now but it's still perfectly happy with hundreds of thousands of rows and 100 or so tables of data performing very complex calculations.
Visual Studio makes it very simple to use SQL server too. Have a look into using datasets with SQL.
Also, here's some nice videos from Microsoft.
[TW]Fox;14815474 said:Not for development, just for data mining that sort of thing really?