25112
asked on
changing data types across the database
when i used SELECT * INTO NEWTABLE FROM OLDTABLE
it recreates the VARCHAR fields into NVARCHAR..
there are many such tables now in the database. Is it possible to correct them all through a UPDATE or ALTER Query?
it recreates the VARCHAR fields into NVARCHAR..
there are many such tables now in the database. Is it possible to correct them all through a UPDATE or ALTER Query?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.