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,682 reads
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,682 reads
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,192 reads
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Hi, We have a user that is not an administrator that says when they...
Hello, I was looking over the Edition specifications, and Standard is capped at 128...
A client of ours is upgrading their database to SQL Server 2019. The edition...