Pastable version of Cache SQL Server Views

<div style="overflow:auto;border:solid 1px #ccc;background:#000;color:#F8F8F8">
          <div class="section">
            <span style="margin:0;padding:4px 6px;font-size:12px;float:right;">Statement</span>
            <pre style="float:left;margin:0 10px;border-right:0;color:#666;">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23</pre>
            <pre class="sunburst">Declare @Name <span style="color:#99CF50;">varchar</span>(<span style="color:#3387CC;">128</span>)
Declare @Cursor Cursor

<span style="color:#E28964;">Set</span> @Cursor = Cursor For <span style="color:#E28964;">Select</span> Name <span style="color:#E28964;">From</span> SysObjects <span style="color:#E28964;">Where</span> XType = <span style="color:#65B042;"><span style="color:#65B042;">'</span>V'</span>

Open @Cursor

Fetch Next <span style="color:#E28964;">From</span> @Cursor Into @Name
While @@Fetch_Status = <span style="color:#3387CC;">0</span>
<span style="color:#E28964;">Begin</span>
	Declare @Table <span style="color:#99CF50;">varchar</span>(<span style="color:#3387CC;">128</span>)
	<span style="color:#E28964;">Set</span> @Table = <span style="color:#65B042;"><span style="color:#65B042;">'</span>c'</span> + SubString(@Name, <span style="color:#3387CC;">2</span>, <span style="color:#3387CC;">128</span>)
	If Exists(<span style="color:#E28964;">Select</span> Name <span style="color:#E28964;">From</span> SysObjects <span style="color:#E28964;">Where</span> Name = @Table)
	<span style="color:#E28964;">Begin</span>
		Print <span style="color:#65B042;"><span style="color:#65B042;">'</span>Drop Table '</span> + @Table
		Exec(<span style="color:#65B042;"><span style="color:#65B042;">'</span>Drop Table '</span> + @Table)
	End
	Exec(<span style="color:#65B042;"><span style="color:#65B042;">'</span>Begin Tran Select * Into '</span> + @Table + <span style="color:#65B042;"><span style="color:#65B042;">'</span> From '</span> + @Name + <span style="color:#65B042;"><span style="color:#65B042;">'</span> Commit'</span>)
	Fetch Next <span style="color:#E28964;">From</span> @Cursor Into @Name
End

Close @Cursor
Deallocate @Cursor
</pre>
          </div>
        </div>

<a href="http://www.refactormycode.com/codes/347-cache-sql-server-views" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

counter free hit invisible