Re: MSSQL vs. SYBASE

From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 22:06:47 +0000 (UTC)

Lewis Howell (lou_junkmail@yahoo.com) writes:
> Adding RAISERROR is not an option, we would have to edit 1,000+ stored
> procs ().

Then you would have to tame ADO. It's not impossible, but I have to
admit that it's definitely not my top pick for this task. A DataReader
in ADO .Net would be much nicer, but alas .Net is out of reach for
you from Delphi.

But I am curious, your description:
 
>> > I am converting to MSSQL SERVER from SYBASE. In our client side
>> > application we use callback procedures with CT_LIB to get information
>> > back from the server during a lengthy process or an infinite (looping)
>> > process controlled by or called within a stored procedure. I can not
>> > find any type of callback for MSSQL.
>> >
>> > Example, I would normally have a SELECT statement within my loop or
>> > beginning of an infinite stored procedure or any stored procedure which
>> > would make the stored proc have multiple result sets. The contents of
>> > the SELECT would be my feedback that would be processed by the callback
>> > procedure in SYBASE. With MSSQL, only if I cancel the stored proc then
>> > all the SELECTs come back at one time in the end...they do not get
>> > returned at any ohter point.

Having such procedures does not strange to me. Neither does having over
1000 stored procedures in one database. But over 1000 stored procedures
of this kind? That was surprisingly many to me. 

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Relevant Pages

  • Re: LINQ Queries vs Stored Procs
    ... Stored Procedures, you can limit the user to only executing stored ... most sql injection attacks, which are more possible with dynamic sql. ... Also about the security aspects: it's not as you claim it to be: I can ... I as a user in Marketing have to use your app which uses procs and I ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Brackets and special characters -- Brain Teaser
    ... because we dont have brackets around our table names. ... > are stuck with about two hundred stored procedures which don't have ... Unfortunately we cant strip special characters ... > procs query this db. ...
    (microsoft.public.sqlserver.programming)
  • Re: Newbie: Stored Procedures and Or Datasets ?
    ... > be a concensous that Stored Procedures are the most effective means to ... > mena less database access, can be optimised by the DBMS or Database ... query with parameters: procs are not precompiled. ... My .NET Blog: http://weblogs.asp.net/fbouma ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Sybase ASE - track all changes in DB made by a stored procedure
    ... I suppose that you can do a code analysis to try to see which procs ... are called from your proc, and which tables these modify, etc. ... code in the database). ... I have a bunch of undocumented stored procedures. ...
    (comp.databases.sybase)
  • Re: Simple Best Practice Question
    ... I am unsure how to go about this. ... > In short the answer is Stored Procedures ... edit and delete records or do I use stored procedures?? ... >> Many thanks in advance for any assistance ...
    (microsoft.public.sqlserver.programming)