skip to main | skip to sidebar

me7486 blog

Thursday, October 15, 2009

SQL Management Studio Find and Replace Generated Script Tag with Variable

Replace generated script tags for values with variable

e.g. ,[SURNAME] =

becomes
,[SURNAME] = @SURNAME

use find and replace with regular expression
find expression: \<{:w+},[^\>]+\>
replace expression: @\1

This is useful for sql studio generated insert and update script
Posted by me7486 at 8:48:00 PM No comments:
Labels: Regular Expression, SQL, SQL Management Studio, SQL Query
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

My Links

  • ANZ Bank Internet Banking
  • ASB Bank Internet Banking
  • NZ FreeView TV Guide
  • TelstraClear My Profile
  • TelstraClear TV Guide
  • Vodafone NZ Service Login

IT Dev Links

  • CodePlex Microsoft Open Source
  • Microsoft ASP.NET Official Site
  • OmegaMan's Musings .NET Info
  • Scott Gu's Blog
  • VMWare Fusion Forum

Blog Archive

  • ►  2011 (2)
    • ►  May 2011 (2)
  • ►  2010 (1)
    • ►  January 2010 (1)
  • ▼  2009 (13)
    • ▼  October 2009 (1)
      • SQL Management Studio Find and Replace Generated S...
    • ►  July 2009 (2)
    • ►  June 2009 (2)
    • ►  May 2009 (1)
    • ►  March 2009 (1)
    • ►  February 2009 (3)
    • ►  January 2009 (3)
  • ►  2008 (34)
    • ►  December 2008 (4)
    • ►  November 2008 (2)
    • ►  October 2008 (5)
    • ►  September 2008 (2)
    • ►  August 2008 (1)
    • ►  July 2008 (11)
    • ►  June 2008 (9)

About Me

me7486
Auckland, New Zealand
IT Worker
View my complete profile