script issue Transact-SQL
sql, sql-server, stored-procedures, t-sql
Solution
declare @tableName varchar(100)
You need to define the length of @tableName, by default it is set to 1 character.
Problem
I Want to return All table names from a use data base but this just return a char ``` declare @contador int set @contador = 1 while (@contador<=(select count(table_name) from INFORMATION_SCHEMA.TABLES)) begin declare @tableName varchar set @tableName = (select top 1 * from (select top(@contador) table_name from INFORMATION_SCHEMA.TABLES order by table_name asc) as nombre order by table_name desc) print @tableName set @contador = @contador + 1 end ``` the output is s s s s s s