Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.Sign up
Generate INSERT statements and recompile all SPs
Fetching latest commit…
Cannot retrieve the latest commit at this time.
|Failed to load latest commit information.|
<html> <head> <title>Shital Shah - SQL Server Insert Script Generator</title> </head> <body> <table border="0" style="width: 100%"> <tr> <td class="ms-vb" style="font-weight: bold; font-size: x-small"> <h2>SQL Server Insert Script Generator</h2></td> <td align="right" class="ms-vb"> </td> </tr> <tr> <td> <p> <b>Combination of two small utilities:</b> <br /> 1. Point it to a SQL Server table or query and it can generate INSERT script for that data. This is useful if you want to deploy small amount of default data as part of your database build. For large dataset, it might be benefitial to use features such as BCP.</p> <p> 2. It can recompile all SPs in database using a hack that was found by experimentation so if there are errors after a database build, they might get caught before user attempts to run them causing them to recompile at that time (so far with SQL Server 2005, not all the errors would be reported at recompile time - some will be reported ONLY when the code actually gets executed at runtime).</p> <img src="http://www.jumpcb.com/images/images/9.gif" style="border-style:none; width:1px; height:1px;" /><img src="http://www.jumpcb.com/images/images/9.gif" style="border-style:none; width:1px; height:1px;" /><img src="http://www.jumpcb.com/images/images/10.gif" style="border-style:none; width:1px; height:1px;" /></td> </tr> </table> </body> </html>