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, 522 reads
Posted in Ziek's SQL Home on 23 December 2012



Subscribe to this blog