|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Interesting but apparently harmless bug in QA when using [TAB]but I haven't checked). Create a sproc in the QA but, instead of a space between CREATE and PROCEDURE, use a [TAB]. In the Sproc add a CREATE TABLE statement - two or 3 fields will do it. Save the Sproc When you open the sproc for editing the the QA, any CREATE becomes ALTER. Again, Tech Support in India has verified this behavior. However, when you open the sproc in the EM, it looks OK. So maybe harmless. -- malcolm Hi
I didn't get the behaviour you described!!! What do you mean by "When you open the sproc for editing the the QA, any CREATE becomes ALTER."? With: CREATE PROCEDURE MyTab AS BEGIN CREATE TABLE #Tmptbl ( id int, col1 char(10), col2 char(1) ) INSERT INTO #Tmptbl ( id , col1, col2 ) SELECT 1, 'A', 'B' SELECT * FROM #Tmptbl END and using the object browser to "Script New Window as ALTER" I get CREATE PROCEDURE! John Show quote "malcolm" <ramarto***@access312.com> wrote in message news:7CE6F0C0-295A-4C34-A9EB-F7C01D397989@microsoft.com... > Bug in Query Analyzer appears after installing SP4 (and maybe earlier SP's > but I haven't checked). > > Create a sproc in the QA but, instead of a space between CREATE and > PROCEDURE, use a [TAB]. > > In the Sproc add a CREATE TABLE statement - two or 3 fields will do it. > > Save the Sproc > > When you open the sproc for editing the the QA, any CREATE becomes ALTER. > > Again, Tech Support in India has verified this behavior. > > However, when you open the sproc in the EM, it looks OK. > > So maybe harmless. > -- > malcolm I think he may be talking about the Access UI. I seem to remember that
behavior. --Mary On Sun, 28 Aug 2005 14:30:20 +0100, "John Bell" <jbellnewspo***@hotmail.com> wrote: Show quote >Hi > >I didn't get the behaviour you described!!! What do you mean by >"When you open the sproc for editing the the QA, any CREATE becomes ALTER."? > >With: > >CREATE PROCEDURE MyTab AS >BEGIN > CREATE TABLE #Tmptbl ( id int, col1 char(10), col2 char(1) ) > INSERT INTO #Tmptbl ( id , col1, col2 ) > SELECT 1, 'A', 'B' > > SELECT * FROM #Tmptbl >END > >and using the object browser to "Script New Window as ALTER" I get CREATE >PROCEDURE! > >John > >"malcolm" <ramarto***@access312.com> wrote in message >news:7CE6F0C0-295A-4C34-A9EB-F7C01D397989@microsoft.com... >> Bug in Query Analyzer appears after installing SP4 (and maybe earlier SP's >> but I haven't checked). >> >> Create a sproc in the QA but, instead of a space between CREATE and >> PROCEDURE, use a [TAB]. >> >> In the Sproc add a CREATE TABLE statement - two or 3 fields will do it. >> >> Save the Sproc >> >> When you open the sproc for editing the the QA, any CREATE becomes ALTER. >> >> Again, Tech Support in India has verified this behavior. >> >> However, when you open the sproc in the EM, it looks OK. >> >> So maybe harmless. >> -- >> malcolm > That is correct. An Access .adp file: when a stored procedure is
opened for editing, the CREATE PROCEDURE is changed to ALTER PROCEDURE. Not a but, just Access. -- Show quoteMGFoster:::mgf00 <at> earthlink <decimal-point> net Oakland, CA (USA) Mary Chipman [MSFT] wrote: > I think he may be talking about the Access UI. I seem to remember that > behavior. > > --Mary > > On Sun, 28 Aug 2005 14:30:20 +0100, "John Bell" > <jbellnewspo***@hotmail.com> wrote: > > >>Hi >> >>I didn't get the behaviour you described!!! What do you mean by >>"When you open the sproc for editing the the QA, any CREATE becomes ALTER."? >> >>With: >> >>CREATE PROCEDURE MyTab AS >>BEGIN >>CREATE TABLE #Tmptbl ( id int, col1 char(10), col2 char(1) ) >>INSERT INTO #Tmptbl ( id , col1, col2 ) >>SELECT 1, 'A', 'B' >> >>SELECT * FROM #Tmptbl >>END >> >>and using the object browser to "Script New Window as ALTER" I get CREATE >>PROCEDURE! >> >>John >> >>"malcolm" <ramarto***@access312.com> wrote in message >>news:7CE6F0C0-295A-4C34-A9EB-F7C01D397989@microsoft.com... >> >>>Bug in Query Analyzer appears after installing SP4 (and maybe earlier SP's >>>but I haven't checked). >>> >>>Create a sproc in the QA but, instead of a space between CREATE and >>>PROCEDURE, use a [TAB]. >>> >>>In the Sproc add a CREATE TABLE statement - two or 3 fields will do it. >>> >>>Save the Sproc >>> >>>When you open the sproc for editing the the QA, any CREATE becomes ALTER. >>> >>>Again, Tech Support in India has verified this behavior. >>> >>>However, when you open the sproc in the EM, it looks OK. >>> >>>So maybe harmless. >>>-- >>>malcolm >>  |
|||||||||||||||||||||||
Other interesting topics