ulka salvi wrote:
u can try this
SELECT a,b,c,CAST(d AS float)
AS N 'd',e,f,g INTO dbo.newtable
Ulka
Did not follow.
Example,
create view v_test as select * from test1;
create table test(col1 varchar(12));
I'd like to:
alter table test alter column col1 type varchar(128);
Tried your su
Good morning,
When there are lots of views and complicated dependencies, it is not
easy to alter column from varchar(a) to varchar(b).
Is it possible when defining a view, adding cascade or some other key
word(s) to allow column type change?
When column1 is changed, all related views' colum