Archive for November, 2013

SQL Search – quickly find SQL in SSMS

  •     Find fragments of SQL text within stored procedures, functions, views and more
  •     Quickly navigate to objects wherever they happen to be on a server
  •     Find all references to an objec
  • SQL Search is an add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases.

http://www.red-gate.com/products/sql-development/sql-search/

Advertisements

Date Time Using CMD

Posted: November 22, 2013 in CMD, Uncategorized
Tags: ,

%date:~-4,4%%date:~-7,2%%date:~-10,2%%time:~-11,2%%time:~-8,2%%time:~-5,2%

– Returns date time in YYYYMMDDHHMMSS format.