sql和access数据库生成insert语句，请问怎么写

sql和access数据库生成insert语句，请问怎么写

以前在网上看到的例子，应该就是你想要了

CREATEprocspGenInsertSQL(@tablenamevarchar来自(256))

as

begin

declare@sqlv训长她东倒现深计品程archar(8000)

贵教满declare@sqlValuesvarchar(8000)

set@sql='('

set@sqlValue360问答s='values(''+'

s绿断镇句裂elect@sqlVal米夜还文下财例斤ues=@sqlValues+cols+'+'',''+',@sql=@sql+'['+name+'],'

from

(selectcase

whenxtypein(48,52,56,59,60,62,104,106,108,122,127)

then'casewhen'+name+'isnullthen''NULL''else'+'cast('+name+'asvarchar)'+'end'

whenxtypein(58,61)

then'casewhen'+name+'isnullthen''NULL''else'+'''''''''+'+'cast('+name+'asvarchar)'+'+'''''''''+'end'

whenxtypein(167)

then'casewhen'+name+'isnullthen''NULL''else'+''''''孙妈'''+'+'repl临受ace('+name+'聚脱牛识响但队请相,'''''''',''''纸绿罗为激龙的联管判刚'''''''')'+'+'''''''''+'end'

whenxtypein(231)

then'casewhe厚纪古龙乡推京散硫怕n'+name+'isnullthen''NULL''else'+'''N''''''+'+'r直察们玉非束eplace('+name+','''''''','''''''''''')'+'+'''''''''+'end'

whenxtypein(175)

then'casewhen'存细若目业准望困滑时善+name+'isnullthen''NULL''else'+'''''''''+'+'cast(replace('+name+','''''''','''''''''''')asC又环har('+cast(lengthasvarchar)+'))+'''''''''+'end'

whenxtypein(239)

then'casewhen'+name+'isnullthen''NULL''else'+'''N''''''+'+'cast(replace('+name+','''''''','''''''''''')asChar('+cast(lengthasvarchar)+'))+'''''''''+'end'

else'''NULL'''

endasCols,name

fromsyscolumns

whereid=object_id(@tablename)

)T

s诉端et@sql='select父置细鸡氢孙民细''INSERTINTO['+@tablename+']'+left(@sql,len(@sql)-1)+')'+left(@sqlValues,len(@sqlValues)-4)+')''from'+@tablename

print@sql

exec(@sql)

end

GO

础层父顺电使用方法

execspGenInsertSQL表名