hi i am trying something like this

declare @sql nvarchar(255);

set @sql = 'SELECT  Distinct(Table_Name) into #diff

FROM'  +[@DbName]+ N'.INFORMATION_SCHEMA.COLUMNS where DATA_TYPE in ('text', 'ntext', 'image','timestamp') ';

i am getting the following error

Incorrect syntax near  'text'