Description: 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.
To Search:
File list (Check if you may need any files):
lab1.sql
Download