DECLARE @Columns integer
DECLARE @sql varchar(max)
DECLARE @TABLE_NAME varchar(80)
SET @TABLE_NAME = 'myTableName'
SELECT @columns=COUNT(*) from information_schema.columns
SELECT @columns
SET @sql = 'INSERT INTO ' + @table_name + ' VALUES('
WHILE (@columns >1)
BEGIN
SET @sql = @sql + 'null'
if(@columns = 2)
BEGIN
SET @sql = @sql + ')'
END
ELSE
BEGIN
SET @sql = @sql + ', '
END
SET @columns = @columns - 1
END
SELECT @sql
DECLARE @Columns integer
DECLARE @iloop integer
DECLARE @sql varchar(max)
DECLARE @TABLE_NAME varchar(80)
SET @TABLE_NAME = 'myTableName'
SELECT @columns=COUNT(*) from information_schema.columns
SELECT @columns
SET @sql = 'INSERT INTO ' + @table_name + ' VALUES(' + REPLICATE('null, ',@columns-1) + ')'
SELECT @sql
declare @mytable as table(id int identity, mytext varchar(20) default 'hello, world' null, mydate date default getdate() null, mybit bit NULL);
insert into @mytable values (default, default, default)
select * from @mytable