Get insert SQL for table data

DECLARE @TABLE_NAME varchar Set @TABLE_NAME = ' myFunction '   -table name DECLARE @TABLE_CONDITION VARCHAR set @TABLE _condition = ' where application= ' 0303 ' and  functiontype= ' function '    --conditional declare @sql VARCHAR  Set @sql = ' DECLARE @col varchar  Set @col = ' DECLARE @scol varchar ' Set @scol = ' SELECT @[email protected]+ ' , ' +name       , @[email protected]+ ', ' ' +isnull (CONVERT (varchar), ' +name+ '), ' ") +" "from syscolumns Where id=object_id (@TABLE_NAME) Set @col =right (@col, LEN (@col)-1) Set @scol =substring (@scol, 2,len (@scol)-1) + "--  Select  @col, @scolset @sql = ' Select  ' insert INTO ' + @TABLE_NAME + ' (' [email protected]+ ') VALUES (' +  @scol + ') + ') ' from ' [email protected]_name+ ' + @TABLE_CONDITION   EXEC (@sql)