Jeff's SQL Server Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server
posts - 157, comments - 2686, trackbacks - 64

My Links

Advertisement

News

Welcome to my weblog. My name is Jeff Smith, I am software developer in Boston, MA and I was recently named a 2009 SQL Server MVP. Check in frequently for tips, tricks, commentary and ideas on SQL Server and .NET programming.


Subscribe





Archives

Post Categories

Programming

Sports

SQL

MS Access

Yep ... MS Access. It's great. When used correctly, it is one of the handiest things you can use to complement your SQL development.
What I learned about SQL from using Access

Microsoft Access / JET SQL doesn't support cursors; the only way to process rows one by one is using VBA and opening a Recordset. This means that you're stuck using set-based "queries". So ... is this a good thing or a bad thing? A very, very good thing -- in fact, it's what makes Access a great tool for learning SQL! read more...

posted @ Wednesday, June 13, 2007 1:12 PM | Feedback (13) | Filed Under [ Miscellaneous Techniques MS Access ]

Convert Microsoft Access (JET SQL) to SQL Server (T-SQL) Cheatsheet

Lots of questions come up in the SQL Team forums about conversions between Access and T-SQL and some of the differences between the two SQL dialects. Here's a nice list of handy things to help you out with converting your projects.

read more...

posted @ Friday, March 30, 2007 3:02 PM | Feedback (38) | Filed Under [ T-SQL MS Access ]

Discussing VB and/or MS Access in a Programming Forum

So, you've decide to write a comment about how bad either VB and/or MS Access is in a programming forum! Well, you've come to the right place, I'm here to help. read more...

posted @ Tuesday, June 06, 2006 7:52 PM | Feedback (38) | Filed Under [ MS Access Humor ]

Powered by:
Powered By Subtext Powered By ASP.NET