I have a database created in Microsoft SQL 2000 Enterprise Manager. I need to change the datatype for a column name EngrMultiplier in the table ProjectReCapParameter. The current datatype is INT and I would like to replace it to FLOAT. What should I do? Write a query or change the datatype in the table design view? How? Also which version of Visual Studio will be useful to modify the client user web form currently built with .NET Framework 1.1.4322? Please Advise me.
Jump to Post
You can do that with a simple query:
ALTER TABLE ProjectReCapParameter ALTER COLUMN EngrMultiplier float
Here is a full example using temporary tables:
IF OBJECT_ID('tempdb..#ProjectReCapParameter', 'U') IS NOT NULL DROP TABLE #ProjectReCapParameter Create Table #ProjectReCapParameter ( EngrMultiplier int ) Insert Into #ProjectReCapParameter (EngrMultiplier) Values …
All 3 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.