HOW TO check if a temporary table exists before DROPping

To check if a temporary table already exists before DROPping, use

If Object_Id('tempdb..#big') is Not Null

Drop table #big

BTW, Are SQL Server Temp Tables Really Necessary?


Comments

Post a Comment

Popular posts from this blog

30+ GitHub Products & Key Ecosystem Features You Should Know in 2026

Image
GitHub has grown far beyond a place to host code — today it's an entire ecosystem covering CI/CD, AI-assisted development, security, package management, and team collaboration. Whether you're new to the platform or just want a single reference point, here's an alphabetical list of GitHub's major products and features, each linked to its official page - GitHub Actions GitHub Advanced Security GitHub Apps GitHub CLI GitHub Code Review GitHub Code Security GitHub Codespaces GitHub Container Registry GitHub Copilot GitHub Copilot Business GitHub Copilot CLI GitHub Copilot Enterprise GitHub Copilot Extensions GitHub Dependabot GitHub Desktop GitHub Discussions GitHub Education GitHub Enterprise Cloud GitHub Enterprise Server GitHub Gist GitHub Importer GitHub Innovation Graph GitHub Issues GitHub Marketplace GitHub Mobile GitHub Models  (retiring July 30, 2026) GitHub Packages GitHub Pages ...
Read more

HOW TO download files hosted in Azure Web App in bulk

Image
Here are the steps to download all the site files hosted in an Azure Web App service in bulk for local modifications or cloning to another hosting location - 1. Log in to the Azure portal 2. Navigate to your App Service 3. Go to the "Advanced Tools" section  4. Click on "Go" link to launch the Kudu console  5. In the Kudu console, navigate to the "Debug console" and then select "CMD" Once you are in the command prompt, navigate to the "Site" directory and then to the "wwwroot" directory. Your Web App should be located in a subdirectory of "wwwroot" 6. Click on the Download icon on the left of the label "wwwroot" to download all the files in the Web App as a zipped file. Alternatively, if your web app URL is https:// <yourappname> .azurewebsites.net/ insert the word scm after the subdomain name thus - https:// <yourappname> . scm .azurewebsites.net/ This will lead you directly to the Kudu con...
Read more

This Week I Learned - Week 30 2026

Image
This Week I Learned -  * The OpenRouter Pareto Router is a dynamic model selection tool that allows users to select a coding model based on a minimum coding score preference. It maintains a curated shortlist of strong coding models ranked by Artificial Analysis coding percentiles. Users can set a min_coding_score between 0 and 1 to control the strength of the coder they need. The router automatically selects the cheapest model within the chosen tier or the fastest with the Nitro variant. This approach ensures that users receive a strong coder without overspending, as the exact shortlist evolves over time with new models and benchmarks. The OpenRouter API is compatible with most SDKs, allowing for easy integration into applications. * openrouter/auto-beta is a task-aware router. It classifies each request, routes it to the model teams are actually spending on for that kind of task, and filters that choice by the cost-quality tradeoff you set. The response is priced at the routed mo...
Read more