<div>
One option that you can do is to create your &quot;canned&quot; tables in the model database. &nbsp;Once it is there, everytime you create your database, it will automatically be created in your new database. &nbsp;You don't have to create any script to do this because SQL Server will do it for you.<br />
<br />
Hope this helps.
</div>


One option that you can do is to create your "canned" tables in the model database.  Once it is there, everytime you create your database, it will automatically be created in your new database.  You don't have to create any script to do this because SQL Server will do it for you.

Hope this helps.

<div>
<div class="content wysiwyg-content">
Hi..<br />
<br />
I wanted to know if someone can tell me the easiest way to load data into newly created tables.<br />
<br />
Certain tables like &quot;States&quot;, &quot;Countries&quot; i need to constantly reload and reload each time I create my databases. <br />
<br />
I have maybe 10-20 tables that should have &quot;canned&quot; data in them when the tables are created. &nbsp;I would like to have just one script that I can run that will populate the tables.<br />
<br />
I suppose DTS could do something like this, but I was looking to have it all in one .sql file.<br />
<br />
thx<br />
<br />
-ws
</div>
</div>


Hi..

I wanted to know if someone can tell me the easiest way to load data into newly created tables.

Certain tables like "States", "Countries" i need to constantly reload and reload each time I create my databases. 

I have maybe 10-20 tables that should have "canned" data in them when the tables are created.  I would like to have just one script that I can run that will populate the tables.

I suppose DTS could do something like this, but I was looking to have it all in one .sql file.

thx

-ws

Easy way to Load Data into tables?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.