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,679 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,122 reads
Blogs
Welcome to 3Cloud …
By DataOnWheels
A little over a month ago, Pragmatic Works Consulting was a part of a...
Daily Coping 23 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
One Thousand SQL Saturdays (*ish)
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
Forums
Need help to form query to get missing month data
I want to know what are the customers having missing month data based on...
What would cause slow disk access on an AWS EBS SQL Server? (PAGELATCHIO_SH)
I have an EC2 instance (r5a.4xlarge) which should be able to do 2Gbps+ in...
What's Causing the Pushback with DevOps?
Comments posted to this topic are about the item What's Causing the Pushback with...
Ask SSC