create;;procspGenInsertSQL
@TableNameasvarchar(100)
as
--declare@TableNamevarchar(100)
--set@TableName='orders'
--set@TableName='eeducation'
DECLARExCursorCURSORFOR
SELECTname,xusertype
FROMsyscolumns
WHERE(id=OBJECT_ID(@TableName))
declare@F1varchar(100)
declare@F2integer
declare@SQLvarchar(8000)
set@sql='SELECT''INSERTINTO'+@TableName+'VALUES('''
OPENxCursor
FETCHxCursorinto@F1,@F2
WHILE@@FETCH_STATUS=0
BEGIN
set@sql=@sql +
+casewhen@F2IN(35,58,99,167,175,231,239,61)then'+casewhen'+@F1+'ISNULLthen''''else''''''''end+';;else'+'end
+'replace(ISNULL(cast('+@F1+'asvarchar(8000)),''NULL''),'''''''','''''''''''')';;
+casewhen@F2IN(35,58,99,167,175,231,239,61)then'+casewhen'+@F1+'ISNULLthen''''else''''''''end+';;else'+'end
+char(13)+''',''';;
FETCHNEXTFROMxCursorinto@F1,@F2
END
CLOSExCursor
DEALLOCATExCursor
set@sql=left(@sql,len(@sql)-5)+'+'')''FROM'+@TableName
exec(@sql)

go

EXEC spGenInsertSQL *TBLNAME*