Susan Harkins
harkinsss at bellsouth.net
Thu Jan 12 19:44:59 CST 2006
You can click the Design Query button to open a query window and build the query graphically. When you close that window the code does appear in the template, but at the top -- not after the CREATE PROCEDURE statement, as I had expected. I wasn't expecting a graphic designer at all, but if you click the button it's there. I'm wondering if it appears by mistake, or if the feature's just not finished, or if I'm just not using it correctly. Using the template is fine -- but since the query design window does open and the code is transferred to the template when you close it, it seems like it's "supposed" to be that way, regardless of how clumsy it seems to be. Susan H. Hi Susan: I am not sure what the issue is but when I am building a SP, I may use the template to initiate the creation, make any appropriate changes to match my requirements, test until the desired results ate obtained, create a new SP and cut and paste resultant query into the new SP. I understand you can create your own templates but should not be able to over-write system the template/samples. Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: January 12, 2006 12:15 PM To: SQL Server List Subject: [dba-SQLServer] Another Express question Has anyone tried Management Studios query editor to create a stored procedure? It seems a bit awkward -- I found it easier to use insert the appropriate SQL statement into the template and execute it to save it. Any comments? Maybe I'm doing something wrong? In the stored procedure template, I clicked the Design Query button and used it as if I were creating a view. It did update the template, but very oddly -- the SQL statement was at the top of the template instead of inside the CREATE PROCEDURE statement as I had expected. Perhaps the query editor isn't really supposed to work with stored procedures? Susan H. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.17/226 - Release Date: 1/10/2006