RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Building Database
Table Column Attributes
«Prev
Next»
SQL Database Creation
SQL - Server
What Is Relational Database
Client Server Architecture
SQL Server Services
Starting SQL-Server Services
SQL Server Installation
SSMS Administer SQL-Servers
Query Analyzer
SSMS Wizards
SqlServer Overview Conclusion
Database Relational Concepts
SQL Server Tables
Data Integrity Elements
Business Rules
Database Normalization
Database Denormalization
Primary Keys Unique Constraints
Foreign Keys
Relational Concepts
Column Attributes Table
Table Columns Types
Specifying Length Precision Scale
SQL Allow Null
Specify Default Column Values
Table Identity Columns
Rowguidcol Attribute Flag
Create Transact SQL Datatype
TableColumn Attributes Conclusion
SQL-Server DB Tables
Sql Server Databases
Database Permissions
Database Elements
Transact Sql Statement
Modifying Databases
Create Manage Filegroups
Drop Database
Database Table
Transact Sql Table
Alter Table Modify
Delete Table Sql
Transact SqlSyntax Conclusion
T-SQL Fundamentals
What is SQL?
Statements, batches, and GO
How SQL Server processes Queries
Variables, data types, Expressions
Control-of-flow Constructs
Worked control-flow Example
Module conclusion
Create Transact-SQL Datatype - Exercise
Creating a User-Defined Datatype
Objective:
Create your own datatype.
Exercise Scoring
This exercise is worth a total of 5 points. You will receive up to 5 points for submitting the correct Transact-SQL syntax required to create your own datatype.
Instructions
Construct a Transact-SQL statement that creates a user-defined datatype with the following attributes:
Name the datatype
zipcode
.
Base it on exactly 5 characters.
Allow NULL values.
Submitting the Exercise
Type or paste your Transact-SQL statement into the text box above, then click
Submit
to submit your answer and view a results page.