Re: UDF/SP Editor

From: Delbert Glass (delbert_at_noincoming.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 17:28:31 -0600

"EDAK" <anonymous@discussions.microsoft.com> wrote in message
news:2304A634-EE9B-406A-8AC6-14BF754A1F0D@microsoft.com...
> Hi folks, I am coming over here to SQL Server from the Oracle world and am
now learning SS2K. I have built several stored procedures and several user
defined functions and am sorely dismayed at the capabilities, or lack there
of, of the editor that is used in SS2K's enterprise manager to construct
stored procedures and UDF's. There has got to be a better editor to enter
new UDF's, stored procedures, triggers and the like than this piece of junk.
Where is the debugging functions that I've become accustomed to in VS?
Where's the tool tips? I might as well use notepad. This is analogous to
using notepad to construct HTML and Jave script for Pete's sake. If the
rest of SS2K is indicative of this, I'm going back to Oracle.

It is not an indication of the rest of SS2K,
it's an indication that you unaware of SQL Query Analyzer
and/or what it's for/does.

You should be using SQL Query Analyzer
instead of SS2K's enterprise manager
for the tasks you are/are-wanting to do.

Bye,
Delbert Glass

Relevant Pages

  • Re: UDF/SP Editor
    ... now learning SS2K. ... I have built several stored procedures and several user ... I might as well use notepad. ... rest of SS2K is indicative of this, I'm going back to Oracle. ...
    (microsoft.public.sqlserver.programming)
  • SOLVED!!!!! iis/asp + sql2000 a bit slow
    ... I created a stored procedure from within SQL Query Analyzer and NOT from ... I changed the ASP page to not use DNS names but instead use SQLOLEDB. ... Set RS = Connection.Execute("SET ARITHABORT ON") ... MySQL - once stored procedures and such are support on MySQL that is. ...
    (microsoft.public.inetserver.asp.db)
  • Re: What is Oracles version of MS SQL Profiler
    ... Tracking code path of a stored procedure (find out what is being ... I'm new to Oracle coming in from Sql Server. ... what I use to debug stored procedures and track performance. ...
    (comp.databases.oracle.server)
  • Re: Passing Back Table Information from Oracle .NET Stored Procedures
    ... Its an abstract way to talk to databases, and there is an Oracle concrete ... > I am working with Oracle .NET Stored Procedures. ... The Oracle namespace has a datareader just like the MS SQL Server namespace has a datareader. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: how to code to avoid SQL insertion attacks
    ... > However i see only 1 reasonable reply, and that is to use stored procedures, ... He only mentioned Oracle after I queried him about it. ... In SQL, ... that is also an egregious programmer error which just as well could ...
    (comp.lang.java.programmer)