Thursday, 12 May 2016

Column name max char 128 and table name max char 116

Column name max char 128

declare @i varchar(800)
select @i=REPLICATE('S',300)
select @i='create #into a('+@i+' int)'
print @i
exec @i

table name max char 116
declare @i varchar(800)
select @i=REPLICATE('S',300)
select @i='create #into '+@i+'(a int)'
print @i
exec @i

No comments:

Post a Comment