Sunday 6 October 2013

11. You need to store the details of the offices in the central database, PictureLibrary. Write the SQL statement to create the OfficeLocation table in the PictureLibrary database. The following table shows the structure of the OfficeLocation table.









Use PictureLibrary
Create table OfficeLocation
(
Office_ID int not Null,
Office_Manger varchar(30) not Null,
Office_Lication Geography not Null
)

No comments:

Post a Comment