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
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