Yes, I'm currently working with Access. And boy thats fun. Is there a way to generate the SQL create script for a group of tables in Access and then run that against another Access database? The ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

I am working on a DB project for school and am almost ready to create my tables. I am unsure as to when I turn on referential integrity. Do I create the tables, do my initial data import, and then ...

One new feature in SQL Server Management Studio 2008 is the ability to restrict changes that would force a table to be re-created. This is a safety valve which can be turned off, if you choose ...

Table creates a SAS data file; View creates a PROC SQL view. When you select OK, the query is processed and a window verifies the SAS table's creation, as shown in the following display.

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships.