Free for PREMIUM members
Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
DECLARE @VarQuery VARCHAR(8000)
SELECT @VarQuery = ISNULL(@VarQuery + ';' , '' ) + 'ALTER TABLE ' + TAble_Name + ' ALTER COLUMN '
+ Column_Name + ' VARCHAR(' + CAST(Character_MAximum_length as VARCHAR(12)) + ') ; '--, *
FROM Information_schema.columns where Data_type = 'nvarchar'
Open in new window
ALTER COLUMN Test Format VARCHAR(20) ; ;ALTER TABLE test ALTER COLUMN col1 VARCHAR(50) ; ;ALTER TABLE test ALTER COLUMN col2 VARCHAR(50) ;
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.