mcrmg

<div>
<blockquote>No. SQL as language does not support this. Only your used tools can do this.</blockquote>Hmm, I think there is. &nbsp;Use sqlcmd (or osql in olded versions of SQL Server where sqlcmd is not available).
</div>


<div>
<div class="content wysiwyg-content fr-view">
I have a Sql file, not a sp. I would like to break it into two sql file, file a and file b. Is there a way to call file B with parameters from file A?<br><br>thanks
</div>
</div>



I have a Sql file, not a sp. I would like to break it into two sql file, file a and file b. Is there a way to call file B with parameters from file A?
thanks

Calling a Sql file with parameters from another sql file

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.