Tag: sql server

Community

SQL Commands

by James Crowley – SQL statements are used by Access, ADO, Oracle, Informix, and not suprisingly, MS SQL server. In short, if you use databases, be it in VB, ASP, FoxPro, Access or anything else, at some stage you will need to know SQL. SQL, or Structured Query Language gives you complete control ov

Community

Upsize Jet Crosstab Queries

by Roger Jennings – Crosstab queries have been a primary selling point for Access since Microsoft released version 1.0 in 1993. A multitude of Visual Basic developers depend on Access’ Crosstab Query Wizard to create persistent QueryDef objects or as a helper for generating Jet crosstab SQL statemen

Community

Flawed Patch Pulled by Microsoft

By Thor Olavsrud – Microsoft Corp. pulled a patch to a security vulnerability off its public Web site after system administrators reported errors loading the patch onto their systems. After receiving reports of the flawed patch, the Microsoft Security Response Center said it would work to cor

Community

Saving on SQL script time

IT-Map International of Wheeling, Ill., launched its dbPAL toolkit at the Borland Conference in Long Beach, Calif. The dbPAL technology provides a suite of tools linked by a user interface that uses a drag-and-drop, icon-based approach instead of having to write SQL scripts, IT-Map said.