往数据表中插入 "字段名 字符串" , 对于非字符字段,采用 "递增整形数字" 代替(日期字段会自动转变为对应日期)

举例如下其中第一行为数据表的字段

第二行为插入数据

column1
column2
column3column1column2column3

代码如下: 其中  "SLS_SalesOrderHD" 为表名,请根据需要修改

insert into SLS_SalesOrderHD(doccode,formid) values('doccode','21101') --先插入一行数据

declare @i int --下面的操作实际上是对之前插入的数据行进行修改

set @i = 1

declare @i_to_str nvarchar(10)

declare cur cursor for select name from syscolumns where id = object_id('SLS_SalesOrderHD') 

open cur

declare @column_name nvarchar(max)

fetch next from cur into @column_name

while (@@fetch_status=0)

begin

fetch next from cur into @column_name

begin try

exec('update SLS_SalesOrderHD set ' + @column_name + ' = ''' + @column_name + ''' where DocCode = ''doccode''')

print @column_name + '''s value = ' + @column_name

print ''

print ''

print ''

end try

begin catch

set @i_to_str = convert(varchar(10),@i)

exec('update SLS_SalesOrderHD set ' + @column_name + ' = ' +  @i_to_str  + ' where DocCode = ''doccode''')

print '------------------' + @column_name + ' type error'

print @column_name + '''s value = ' + @i_to_str

print '------------------'

set @i += 1

--print ERROR_MESSAGE()

end catch

end

close cur

deallocate cur