SQL Tips and Techniques

SQL Tips and Techniques - Chapter 1

• Understanding the MS-SQL Server TempDB Database


• Understanding How to Size MS-SQL Server Databases and Transaction Logs


• Using DROP DATABASE to Erase an MS-SQL Server Database and Transaction Log
  
• Using the MS-SQL Server Enterprise Manager to Create a Database and Transaction Log
  
• Using the CREATE DATABASE Statement to Create an MS-SQL Server Database and Transaction Log
  
• Using the ED Command Within ISQL to Edit SQL Statements
  
• Using the MS-SQL Server ISQL to Execute SQL Statements from the Command Line or Statements Stored in an ASCII File
  
• Using the MS-SQL Server Query Analyzer to Execute SQL Statements
  
• Understanding SQL Keywords
  
• Understanding the Structure of SQL Statements
  
• Understanding the SQL DBMS Client/Server Model
  
• Understanding Assertions
  
• Understanding the MS-SQL Server IDENTITY Property
  
• Understanding the MS-SQL Server ISNULL() Function
  
• Understanding Constants
  
• Understanding the SQL BIT Data Type
  
• Understanding Standard SQL Datetime Data Types and the DATETIME Data Type
  
• Understanding the MS-SQL Server IMAGE Data Type


• Understanding the LONG (Oracle) or TEXT (MS-SQL Server) Data Type

SQL Tips and Techniques - Chapter 2

• Using the MS-SQL Server Enterprise Manager to Create Tables


• Creating MS-SQL Server Temporary Tables


• Using the Transact-SQL CREATE DEFAULT Statement to Set a Column Default


• Using the MS-SQL Server Stored Procedure sp_bindefault to Bind a User-Created Default to a Table Column


• Using the DEFAULT Clause in a CREATE TABLE Statement to Set Default Column Values


• Using the MS-SQL Server Enterprise Manager to Create a Default for a User-Defined Data Type or Table Column


• Using the MS-SQL Server Enterprise Manager to Create a User-Defined Data Type


• Using the MS-SQL Server Enterprise Manager to Bind a Default to a Data Type or Table Column


• Using the Transact-SQL DROP DEFAULT Statement to Remove a Default from a Database


• Understanding the ALTER TABLE Statement


• Using the ALTER TABLE Statement to Add a Column to a Table


• Using the MS-SQL Server ALTER TABLE DROP COLUMN Clause to Remove a Table Column


• Using the ALTER TABLE Statement to Change to Width or Data Type of a Column


• Using the ALTER TABLE Statement to Change Primary and Foreign Keys


• Using the CREATE TABLE Statement to Assign the Primary Key


• Using the CREATE TABLE Statement to Assign Foreign Key Constraints


• Using the DROP TABLE Statement to Remove a Table from the Database


• Using the DROP VIEW Statement to Remove a View


• Using the MS-SQL Server Enterprise Manager Create View Wizard to Create a View


• Understanding the CASCADE and RESTRICT Clauses in a DROP VIEW Statement