•
•
•
•
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 402,931 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,045 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: 30853 | 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
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded 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
