How to change the data type of an existing column with "alter table" s

How to change the data type of an existing column with "alter table" statements in ms sql server?

Question Posted / sanjeev saxena

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

What is a trigger? Why we need it?

what does the automatic recovery do? : Sql server administration

What is the synonym of join?

What is the STUFF function and how does it differ from the REPLACE function?

What is the maximum size of a dimension? : sql server analysis services, ssas

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

What is the return type of executeupdate ()?

How to update muliple row in single query?

Define constraints and give an example of their use?

Can we create clustered index on non primary key column

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

What is the difference between truncate and delete commands?

For more SQL Server Interview Questions Click Here