Category: SQL Server

18 Jul 2016 02:42

Joined:	13/08/2015
Level:	Silver
Points:	102

Points:	3

How to Convert a Table Column Float Datatype to Varchar in Sql Server 2008 R2

Hi Developers

In my sSql Database
I have created one Student Marks table and inserted more than
5000 student Marks with Float Data Type,
Now i want to insert Text also. So how can i convert the Mark Column Float datatype to Varchar datatype.
Please help me friends for i am done this task

Thanking You
Paul.S

#767193

18 Jul 2016 03:22

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	2

Hi,

If you want to ALTER your table structure then refer below Microsoft Syntax, this might be helpful to change your table column datatype.


ALTER TABLE tablename
ALTER COLUMN coulumnname  VARCHAR(100)

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

#767202

18 Jul 2016 23:49

Joined:	13/08/2015
Level:	Silver
Points:	102

Points:	1

Thanks Mr.Naveen Your Query is working exactly.

by,
Paul.S

#767205

19 Jul 2016 01:37

Joined:	15/12/2015
Level:	Gold
Points:	1308

Points:	2

Hi,
Also you can use Str() function of SQL:


DECLARE @num float = 1234567890;    
SELECT Str(@num, 20, 5);
Insert into  Table (FloatColumn) values (Str(@num, 20, 5))

#767211

19 Jul 2016 02:55

Joined:	05/06/2009
Level:	Gold
Points:	10245

Points:	3

1. Create new column "FloatStudentMarks " of type Text
2. Update the new column with "StudentMarks". "Str" method to convert.
3. Now you can delete the old column(StudentMarks) and rename the "FloatStudentMarks " into "StudentMarks"

I hope the above logic will help you changing the column type. You can also alter table. But there may a change possibility of loose of data. If you do the above logic. You may make sure by seeing the converted data and the remove the old column.

By Nathan
Direction is important than speed

#767218

19 Jul 2016 04:39

Joined:	13/06/2007
Level:	Gold
Points:	21327

Points:	2

Just ALTER it using following syntax


ALTER TABLE tablename ALTER COLUMN coulumnname  datatype(size)
//here you can use below syntax
ALTER TABLE tablename ALTER COLUMN coulumnname  VarChar(1000)

Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]

How to Convert a Table Column Float Datatype to Varchar in Sql Server 2008 R2

About dotnetspider.com

Quick Links

General

Services