•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 423,716 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,164 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 32976 | Replies: 4
 |
•
•
Join Date: Feb 2005
Posts: 175
Reputation: 
Rep Power: 4
Solved Threads: 5
Junior Poster
Hello,
I want to change the datatype of a field from Varchar to integer in T-SQL.
I tried something like Modify like you use in Oracle.
ALTER TABLE tablename
MODIFY COLUMNNAME Datatype.
But its not working in SQL server..
Any thoughts.
I want to change the datatype of a field from Varchar to integer in T-SQL.
I tried something like Modify like you use in Oracle.
ALTER TABLE tablename
MODIFY COLUMNNAME Datatype.
But its not working in SQL server..
Any thoughts.
Save White Tiger
•
•
Join Date: Jul 2005
Posts: 19
Reputation:
Rep Power: 4
Solved Threads: 0
Newbie Poster
i am not very sure is it different as in SQL where yu can go to the database that you want and then you go to the table and then you click the right side of yur mouse and go to design table and change it
•
•
Join Date: Feb 2005
Posts: 175
Reputation:
Rep Power: 4
Solved Threads: 5
Junior Poster
I changed it. I went to enterprise Manager and went to design view of the table and changed the data type of the field.
Thanks anyway
Thanks anyway
Save White Tiger
•
•
Join Date: Feb 2005
Posts: 175
Reputation:
Rep Power: 4
Solved Threads: 5
Junior Poster
Thanks Wchitamb.
Save White Tiger
•
•
Join Date: Jul 2005
Location: Portugal
Posts: 13
Reputation:
Rep Power: 4
Solved Threads: 0
Newbie Poster
G'd evening!
In case you still need to change the table's column type from T-SQL , the sintax for MS SQL is:
ALTER TABLE table ALTER COLUMN column_name new_data_type
Ex.
ALTER TABLE MyTable ALTER COLUMN MyColumn NVARCHAR(20)
For more about the Alter Table sintax, read the books on line (BOL), here is the last update for SQL 2k SQL Server Books Online January 2004 Update
Good luck
Estuardo
In case you still need to change the table's column type from T-SQL , the sintax for MS SQL is:
ALTER TABLE table ALTER COLUMN column_name new_data_type
Ex.
ALTER TABLE MyTable ALTER COLUMN MyColumn NVARCHAR(20)
For more about the Alter Table sintax, read the books on line (BOL), here is the last update for SQL 2k SQL Server Books Online January 2004 Update
Good luck
Estuardo
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- C++ enumerated data type help (C++)
- SQL Create table error (ASP.NET)
- dynamic td's not tr's (ColdFusion)
- Good Luck w/This one: Excel Question VBA/Macro/other (MS Access and FileMaker Pro)
Other Threads in the MS SQL Forum
- Previous Thread: how do I run a "disconnected" stored procedure
- Next Thread: tricky SQL query
