Wednesday 9 October 2013

03. Write an SQL statement to insert a record into the OfficeLocation table, which is created in the PictureLibrary database. The following table shows the data to be inserted into the OfficeLocation table.





Use PictureLibrary
go
Insert into OfficeLocation(Office_ID,
Office_Manager,Office_Location)
Values(1001,'Max',Geography: : Parse('Point(-83.0086 39.95954)'))

No comments:

Post a Comment