September 23, 2004 at 9:47 am
Does anyone know how to dynamically change the templates in QA? I want to change the basic script so it automatically includes a comment section with a GETDATE() stamp, the SYSTEM_USER, and a space for the procedure description. I know how to create a new template with static text, but I want it to be dynamic and automatically include at least the two things mentioned above.
September 23, 2004 at 11:31 am
I don't think so..... I would save a template to a SQL file, and run it, then don't save it so you still have the original template.
September 23, 2004 at 11:33 am
I guess I should add that if you could, it would be by putting a template in the model database.
September 23, 2004 at 12:04 pm
It's not the most elegant solution, but you can use parameters in your template. The syntax for creating a parameter is:
<parameter_name, data_type, value>
Use the Replace Template Parameter Dialog (Ctl+Shift+M) to replace the value in the parameter.
I'm not sure this will get you what you want but its somewhere to start.
September 24, 2004 at 10:21 am
Thanks Peter! This is just the lead I was looking for.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply