<div>
Thanks, it was the creation and execution of the command that was the part I was missing.<br />
<br />
I guess you can do it with a temp table or a cursor...
</div>


Thanks, it was the creation and execution of the command that was the part I was missing.

I guess you can do it with a temp table or a cursor...

<div>
<div class="content wysiwyg-content">
My company's database has over a hundred files which contain the column &quot;CoreID&quot;. &nbsp;I want to create a SP that will delete all records for a certain value of CoreID.<br />
<br />
I'm guessing I should use a cursor, but I can't find a good example of exactly what I'm trying to do. &nbsp;First, I have an SQL statement that will give me the names of all files which have the CoreID column. &nbsp;For each of those files, I want to DELETE FROM &lt;filename&gt; WHERE CoreID = &lt;some value&gt;<br />
<br />
What should my SQL look like?<br />

</div>
</div>


My company's database has over a hundred files which contain the column "CoreID".  I want to create a SP that will delete all records for a certain value of CoreID.

I'm guessing I should use a cursor, but I can't find a good example of exactly what I'm trying to do.  First, I have an SQL statement that will give me the names of all files which have the CoreID column.  For each of those files, I want to DELETE FROM <filename> WHERE CoreID = <some value>

What should my SQL look like?


How to perform an action on each of a list of 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.