I've been tasked with doing a conversion of an Access 2000 app to SQL Server. As of right now, I'm fine with keeping the front end Access, but I wanted to put the back end tables on SQL. I used the ...
In my last column (published in the February e-edition and the March print edition of DBTA), I reviewed the overall coding landscape for SQL Server with special focus on LINQ to SQL, a new technology ...
The authors assume the reader is conversant with SQL as they describe how to apply SQL in a practical manner. If you can't code an outer join or don't know what a nested table expression or in-line ...