SQL Template Parameters -
06-22-2010
, 01:47 PM
I'm creating a SQL Script to distribute to multiple clients. The script will
contain Template Parameters for Database Name, log in, etc... The template
parameters work fine except for the following line of sql code.
IF @fragmentation < @rebuildThreshold Or ISNULL(@containsLOB,0) = 1 Or
ISNULL(@partitionCount,0) > 1
When I execute the template (Ctrl-Shift-M) to fill in the parameters, I get
a parameter named
@rebuildThreshold Or ISNULL(@containsLOB
with a type of
0) = 1 Or ISNULL(@partitionCount
and a default value of
0)
As you can see, my tsql code matches the template parameter declaration.
What can I do to escape this line?
Thanks,
J Reddy |