July 8, 2013 at 8:20 am
I am trying to generate a script with data.
I have imported this data from Excel to SQL and now need to forward the script in SQL to my colleagues in notepad.
I tried to follow the link : http://stackoverflow.com/questions/982568/what-is-the-best-way-to-auto-generate-insert-statements-for-a-sql-server-table
But don't seem to locate the advance button.
Kindly advise
July 8, 2013 at 8:26 am
Hi,
It's found on the set scripting options page... See screenshot attached.
Thanks,
Simon
July 8, 2013 at 8:42 am
Thanks Simon.
Well, My SQL version did not have that button but it has an option in Tables as Script Data and it was supposed to be "On". Figured it out.
July 9, 2013 at 1:57 am
Great! Glad you got it sorted.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply