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

Ziek's SQL Home

Ezekiel is an IT professional with over ten years experience in building database applications and BI/DW solutions. He holds a BSc Computer Science degree from KNUST, Ghana and a MSc Business IT degree from Kingston Business School, London. He has delivered solutions for the Insurance, Banking, Telecom and Housing Industries and his key expertise include developing Microsoft BI/DW solutions, .NET applications, Business Process Improvement and Project Risk Management. He is a Microsoft Certified Professional - MCTS: Microsoft SQL Server 2005 Implementation and Maintenance.

Archives: December 2012

How to drop all tables in a SQL Server Database whose name begins with a common value

Scenario

I have discovered from working on projects that sometimes you may have to make use of temporary or staging tables for things like loading, parsing and data cleansing.  Let’s assume that as per your project or company’s database naming convention, these tables are all prefix with the name/value; “temp_”… Read more

0 comments, 1,009 reads

Posted in Ziek's SQL Home on 23 December 2012