create proc ChangeColumnLength
@P0 varchar(50) --Table Name
as
Begin
declare @Column varchar(50),@SQL varchar(max)
declare mycursor cursor for
select Name from syscolumns where id=OBJECT_ID(@P0) and xtype='167' and length between 1 and 50
open mycursor
fetch next from mycursor into @Column
while(@@FETCH_STATUS=0)
Begin
set @SQL='alter Table '+@P0+' alter column '+@Column+' varchar(max) '
exec(@SQL)
fetch next from mycursor into @Column
End
close mycursor
deallocate mycursor
End