One line to drop a (temp) table if it exists
It is very common to want to drop a table, if it exists, before creating it. This script does so, and it works well with temp tables (where the system views are harder to query).
2008-10-06
2,680 reads
Mike Arney
Java's String.hashCode() function in T-SQL
T-SQL function to takes a string and produce an integer hashcode matching what is produced by the Java String.hashCode() method.
2008-08-04 (first published: 2008-06-11)
1,132 reads
Blogs
The End of PASS
By Andy Warren
I think our profession was the better for having a professional association, even if...
Platforms for Events
By Andy Warren
in my last post I wrote about thinking of the tools as being a...
Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop
By Devin-Knight
There are a lot of hot phrases you’ve likely heard thrown around during various...
Forums
"Home PC" SQL instance
This may be a bit non-typical, but I am currently running SQL 2019 Developer...
Interview question about CPU
Hello SSC friends, I am a SQL Developer who is learning how to be...
Ask SSC