<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a script that i use to generate the tables and views in two databases. &nbsp;In the script there is a view that has a join over tables in both databases.<br />
<br />
The databases can have different names each time i run the script so this affects the database names in the views.<br />
<br />
Is there anyway i can have parameters to a script so i can make it more generic?<br />
<br />
Otherwise i must edit the script each time and there is a risk i make a mistake.
</div>
</div>


Hello,

I have a script that i use to generate the tables and views in two databases.  In the script there is a view that has a join over tables in both databases.

The databases can have different names each time i run the script so this affects the database names in the views.

Is there anyway i can have parameters to a script so i can make it more generic?

Otherwise i must edit the script each time and there is a risk i make a mistake.

Paramter to a script?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.