Home Forums Article Discussions Article Discussions by Author Discuss content posted by Florian Reischl Script all data of a table RE: Script all data of a table

  • July 11, 2009 at 5:07 am

    #1023477

    Linson.Daniel (6/17/2009)

    Nice script there, I too had written a similar script

    http://www.sqlservercentral.com/scripts/insert+script+generator/65407/

    but the bad thing about mine would be the fact that I had made use of cursors....and also since it was written for sql server 2000 it has its limitation when tried in 2005.....

    Hi Daniel

    Sorry for the very late answer!! Seems I lost the response mail...

    Just had a look at your script, maybe you should include QUOTENAME or REPLACE to avoid SQL injection by "'". For smaller tables cursors should be okay.