May 19, 2002 at 12:43 pm
Has anyone any idea if Microsoft, in their infinite wisdom, has any plans to give the SQL Server programmer a more powerful Stored Procedure editor - say something similar to the VB Integrated Development Environment? I for one would love an Intellisense autocomplete that worked with already declared variables and keywords. For that matter, why not be able to drop VB code right into a Stored Procedure? The syntax is currently so similar it's easy to mix them up.
Student of SQL and Golf, Master of Neither
Student of SQL and Golf, Master of Neither
May 19, 2002 at 1:11 pm
From what we saw at PASS in Feb looks like the next version of SQL will have an integrated EM/ISQL tool and it is supposed to include support for .Net languages.
Andy
May 19, 2002 at 6:10 pm
I have also heard mixes of ActiveScripting to come that will replace TSQL itself to make things easier on all developers. Anyone else confirm?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 20, 2002 at 9:44 am
Haven't heard that, but I did hear that Stored procedure can be written in VB.NET, C#.NET, etc. IMHO a bad idea. Fundamental differences between the languages (set v row based). But that's the idea. Not sure how that will work (inheritence, etc).
Steve Jones
May 20, 2002 at 10:11 am
Steve: Now that's what I'm hoping for. The ability to write a SP in VB, using powerful structures like a real Select Case and the non-convoluted If Then Else (I hate the Begin-End pairs), the ability to have Len() mean the same thing in both languages, etc. etc. The holy grail however would be to have all the functionality of the IDE, no matter what the language.
Student of SQL and Golf, Master of Neither
Student of SQL and Golf, Master of Neither
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply