sql

Generate INSERT INTO script for existing data in sql Server 2008
It always amazes me how little features are built into sql Server Management Studio. One of these (trivial) things is to generate a script which inserts existing data. Fortunately, it has become a feature in sql Server 2008. short story: right click the database > tasks > generate scripts > enable %26ldquo;script data%26rdquo; option full story: here