Hello,
I'm trying to get to grips with SQL Server 2005.
One of the things I want to do is provide members of my team with a stored procedure template that they can use which has special error handling code in it , etc
I found my way to the template explorer and created a new template that I want to use to create stored procedures in certain circumstances (but not ALL circumstances)
But now I can't figure out how to specify WHICH template to use when creating a stored procedure.
Like, when I click on the Programmability/Stored Procedures node and then right click and select New Stored Procedure... it just uses the Basic Template.. but I'd like to be able to elect to use my alternative template to create the stored proc.
So, what are the correct steps to follow? do i just double click my new template in Template Explorer? And then have to go Query/Specify Values for Template Parameters ? Or what?
If this is the way to do it then it seems very clunky really....
Thanks
>>But now I can't figure out how to specify WHICH template to use when creating a stored procedure.
>>Like, when I click on the Programmability/Stored Procedures node and then right click and select New Stored Procedure... it just uses the Basic Template.. but I'd like to be able to elect to use my alternative template to create the stored proc.
You can create procedures by double-clicking on the template. Or you may just drag-and-drop any template into the body of any query.
No comments:
Post a Comment