Jet SQL Data Types

by Joe Hunter 8. July 2010 09:55

Table of the 13 primary data types in JET SQL:

T-SQL to drop all non-system databases in SQL server instance EXEC sp_MSforeachdb 'IF DB_ID(''?'') > 4BEGINALTER DATABASE ? SET SINGLE_USER WITH ROLLBACK IM...Exporting data from SQL Server to Access using a Linked ServerSo I found out the hard way that to export data from SQL Server to Microsoft Access requires that th...Backing up SQL server database to a mapped network driveSQL server runs as a service so it does not have access to a network drive mapped as a local drive l...