Trailmax Tech

Max Vasilyev: ASP.Net MVC development in Aberdeen, Scotland
Skip to content
  • My Talks
  • cacheCopy
  • NSaga
  • Cake.SqlServer
  • About

Create Temp Table if not exists

Posted on June 6, 2012July 13, 2013 by trailmax

Often we need to create temp tables, and drop them every time we re-run the script.

-- if table exists, drop it
IF OBJECT_ID('tempdb..#temp') IS NOT NULL
BEGIN
    drop table #temp 
END

create table #temp (id int, name nvarchar(50))
Uncategorized   sql, sql server
0

Tags

.Net asp.net Autofixture automation azure Azure-DevOps bat build server BuildServer c# cakebuild commands Dependency Injection di drivers eclipse EntityFramework git html https Identity iis java javascript jquery Linux microsoft mocking mvc OpenXml recipe regexp Registry script sql sql server stackoverflow testing tfs unit-testing Vista visual studio Windows Wireless XP

Blogroll

  • HR.Net Consaltancy and blog
  • My Git Cheat-Sheet
  • My Twitter
  • Wordpress Hosting

Recent Posts

  • Laundry Basket Bias
  • mstsc.exe vs HD screen
  • Windows Terminal
  • Using private NuGet feed with dotnet publish
  • Keyboard Shortcuts for Git in Visual Studio
Powered by WordPress | Theme: Bootstrap Basic