Home Forums SQL Server 2005 Administering Changing datatype of a column RE: Changing datatype of a column

  • May 12, 2008 at 1:07 am

    #813627

    hi

    First change the datatype as varchar and datime.. it will work...

    create table #a

    (a text

    )

    alter table #a

    alter column a varchar(10)

    alter table #a

    alter column a datetime