This section is designed for for SQL administrators who want to get started with Transact commands. My goal in this section is to help you to write SQL scripts. The purpose of these examples is to show you how to modify existing scripts, or to write a new script which …
This SQL Server 2000 section is designed for: Techies who already know Windows 2000 and want to learn SQL Network administrators who need to configure their SQL Server ‘Newbies’ who want to get started with Transact statements Those with some database experience who wish to plug gaps in their knowledge …
SQL Transact – SELECT Statement SELECT is probably the most versatile and widely used statement in SQL Transact. Another reason to begin with Select is that you are not altering the data so you do not risk destroying data in the tables while you are learning. Lesson 1 – The …
This page explains the factors to take into account when you plan a SQL backup strategy. I give you this as independent advice from someone who visits companies advising them on computer procedures. Overall backup strategy Write ahead log files Log files and restore Backup methods Overall backup strategy The …
SQL Transact INSERT … SELECT Statement This example not only inserts data, but it inserts records with style. INSERT… SELECT works well when you already have the data elsewhere, in another table for example. Lesson 1 – INSERT … SELECT The scenario: You want to add your employees to the …
SQL Transact Insert Statement Once you are familiar with SELECT, then you are ready to experiment with INSERT transact statements. Lesson 1 – INSERT a new customer The scenario: Your production department has just discovered a new supplier. Our job is to enter their details into the Northwind database. Preparation …