SQLServer.sql

-- SQLServer alter varchar(4000) to TEXT
-- mrequest
ALTER TABLE mrequest ALTER COLUMN reason TEXT;
ALTER TABLE mrequest ALTER COLUMN plandesc TEXT;
ALTER TABLE mrequest ALTER COLUMN remark_wf TEXT;
ALTER TABLE mrequest ALTER COLUMN responsibility TEXT;
ALTER TABLE mrequest ALTER COLUMN destination TEXT;
ALTER TABLE mrequest ALTER COLUMN conclusion TEXT;
ALTER TABLE mrequest ALTER COLUMN language TEXT;
ALTER TABLE mrequest ALTER COLUMN behavior TEXT;
ALTER TABLE mrequest ALTER COLUMN position_specific TEXT;
ALTER TABLE mrequest ALTER COLUMN orther_knowledge TEXT;
ALTER TABLE mrequest ALTER COLUMN examdata TEXT;
ALTER TABLE mrequest ALTER COLUMN pregnantdesc TEXT;
ALTER TABLE mrequest ALTER COLUMN qualification TEXT;
ALTER TABLE mrequest ALTER COLUMN software TEXT;
ALTER TABLE mrequest ALTER COLUMN remark_hr TEXT;
ALTER TABLE mrequest ALTER COLUMN other TEXT;
ALTER TABLE mrequest ALTER COLUMN experience TEXT;
ALTER TABLE mrequest ALTER COLUMN impairdesc TEXT;
ALTER TABLE mrequest ALTER COLUMN cancel_reason TEXT;
ALTER TABLE mrequest ALTER COLUMN router TEXT;

-- mapplicant
ALTER TABLE mapplicant ALTER COLUMN jobexp TEXT;
ALTER TABLE mapplicant ALTER COLUMN education TEXT;
ALTER TABLE mapplicant ALTER COLUMN contact TEXT;
ALTER TABLE mapplicant ALTER COLUMN personal TEXT;
ALTER TABLE mapplicant ALTER COLUMN skill TEXT;
ALTER TABLE mapplicant ALTER COLUMN jobrouter TEXT;
ALTER TABLE mapplicant ALTER COLUMN family TEXT;

-- mappointment
ALTER TABLE mappointment ALTER COLUMN detail TEXT;

-- mjobrouter
ALTER TABLE mjobrouter ALTER COLUMN jobrouter TEXT;

-- mexam
ALTER TABLE mexam ALTER COLUMN examdata TEXT;
ALTER TABLE mexam ALTER COLUMN question TEXT;

-- crecruit
ALTER TABLE crecruit ALTER COLUMN object TEXT;