Qiestion about update statement

Assignment Help Software Engineering

Reference no: EM1379019

A table namedPoints varchar(81) has values stored in a column named Point. There are two columns in the Points table, X and Y. Here is the code that constructed the table:
REATE TABLE dbo.POINTS (
I INT IDENTITY NOT NULL
,Point varchar(81) NOT NULL
,X decimal(38,10) NULL
,Y decimal(38,10) NULL
)
GO
INSERT dbo.POINTS (Point) VALUES ('(45.123,22.5)')
INSERT dbo.POINTS (Point) VALUES ('(7.95,3.45)')
INSERT dbo.POINTS (Point) VALUES ('(100.2,15.498)')
GO

I need a query using an UPDATE statement to populate X and Y from Point. THe data on the left side of the comma is X and on the right side of the comma is Y. I am guessing that either Substring or Charindex would beused but I am not sure.

Reference no: EM1379019

Questions Cloud

Implementing reusable code : Many programming languages exist in various libraries and on the Internet and using some of these functions and process, this can permit you to use these technique rather than having to write out the code from scratch on your own.

Creating an idef1x e-r diagram : The scenario is that the Public Affairs Office at Highline University gets requests for speakers on particular topics. To be able to respond to such request, that office wishes to create a database.

Difference between encapsulation and information hiding : Discuss and explain the difference between encapsulation and information hiding. In addition, describe the role both of these concepts play in helping to make designs more robust and extensible.

Indirect port addressing capability : Determine how many ports can the Z8000 address in each I/O addressing mode?

Qiestion about update statement : A table namedPoints varchar(81) has values stored in a column named Point. There are 2-columns in the Points table, X and Y.

Currency conversion event : Expand the Currency Conversion event to have a menu of 5-currencies that allows the user to choose which currency they wish to display in its equivalency to the United States dollars.

Importance of internet to most companies : Discuss how important is the Internet to most corporations? How have corporations improved the sales / service / performance process utilizing the Internet?

Privileges and obligations of a corporation : What should the privileges and obligations of a corporation be from an ethics perspective and how can these be enforced? In a global market, how can a corporation with a strong ethical agenda

Content validation of document : Do you believe that any form of document content validation should be applied to web pages before they are placed in the public domain?

User Account

All Pages