dbTalk Databases Forums  

SQL Template Parameters

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQL Template Parameters in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jreddy
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.