Introduction - If you have any usage issues, please Google them yourself
I. Query with SQL Server 2005. (30’, 2’ for each)
1. Create a table named Student using command Create Table. The table structure is as follows:
Column Type Length Note
ID Varchar 20 Student’s ID
Name Varchar 10 Student’s Name
Age Int Student’s Age
Department Varchar 30 Student’s Dept.