Tag: sql

I know, I know, everything I do is rushed and not properly explained, apologies for that. Anyway.During some investigation, I came across some badly designed tables where most of the columns meant to hold character data were NVARCHAR(MAX), all this while the maximum length of the strings were something in the area of 30-50 characters. … Continue reading Find and Change (N)VARCHAR(MAX) to (N)VARCHAR(XXX) →