This chapter comes from our "SQL Server 2000 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Chapter 7: T-SQL Basics: Queries, Datatypes, Collations and Unicode, and more

This chapter covers many internal storage and retrieval techniques including collations, how datatypes are stored and compared, and working with the internal datatypes

Videos in Chapter 7

1Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server Download
2Defaults and Rules in SQL Server 2000 - What They Are, How to Use Them and Best Practices Download
3Result sets, Recordsets, and the Client Server model Download
4Scalar, System, Built-In and Niladic Functions - What They Are and How to Use Them Download
5Aliasing in Queries - What It Is and How to Use It (SQL Server 2000) Download
6Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work Download
7Creating and Altering Views in the Enterprise Manager (SQL Server 2000) Download
8Creating Linked Servers to Microsoft Access (SQL Server 2000) Download
9Customizing SQL Server with International Error Messages and How SQL Server 2000 Uses the Default Language Download
10Extended Properties in SQL Server 2000 - What They Are and How to Use Them to Generate Your Data Dictionary Download
11How to Return Identity Value for a Just-Inserted Row Download
12Interactive Help and Books Online - Using Context-Sensitive Help (SQL Server 2000) Download
13Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL Server 2000) Download
14Rapid Database Development Using Database Diagrams (SQL Server 2000) Download
15Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000) Download
16Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the Create Stored Procedure Wizard Download
17Views: Introduction, When and Where to Use, and Using the Create View Wizard Download
18Working with User Defined Data Types in the Enterprise Manager (SQL Server 2000) Download
19Pt. 1 - An Introduction to Using Views in SQL Server Download
20Pt. 2 - Using Views in the Real World Download
21Pt. 3 - Create View Syntax and Creating Views in SQL Server Download
22Pt. 4 - Updateable Views in SQL Server (How to Update the Database Through a View) Download

Browse this course's videos now

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.