Sale!

In the SQL Class database create a table called “Employee solved

Original price was: $25.00.Current price is: $20.00.

Download Details:

  • Name: Answer_sol_sqlv02-suo9jm.docx
  • Type: docx
  • Size: 483.37 KB

Category:

Description

5/5 - (2 votes)

Q.1..Write sql statements to do the following
In the SQLClass database create a table called “Employee.” It should contain the following fields that contain information about the employees. Set the EmployeeID as an Identity Key:
a. Employee_ID int
b. EmployeeNumber VarChar (120)
c. Title VarChar (120)
d. Salary Numeric
e. HireDate DateTime
f. CreatedDateTime DateTime