Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Mike Arney

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

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).  Read more...
By Mike Arney 2008/10/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,581 reads

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.  Read more...
By Mike Arney 2008/08/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,045 reads
   Items 1 to 2 of 2