T SQL, how long is that varchar?

Post date: Dec 16, 2009 5:14:09 PM

SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE (TABLE_NAME = 'Nodes') AND (COLUMN_NAME = 'Name')