February 2008 - Posts

• Dynamic Search Conditions in T-SQL

  This is a great article on the best way to build store procedures when you have a requirement for variable clauses on your where statements (e.g. say search for an order by name or order date). Its pretty damn good! Dynamic Search Conditions in T-SQL Neil Posted Feb 19 2008, 06:18 AM by admin with no comments Filed under: Dynamic Search, Store Procedures, TSQL

• Batch Detach Databases

  Run this script and send the results to a text file. The resulting text file is a script to detach every database on the server. --Detaching EXEC sp_MSforeachdb 'IF N''?'' NOT IN(''model'' ,''master'', ''msdb'', ''tempdb'') BEGIN SELECT ''EXEC sp_detach_db ''''?'''',''''true'''''' END'   Posted Feb 15 2008, 06:53 PM by admin with no comments Filed under: Detach SQL2000 SQL2005