search results

  1. Dear All, I have a complex stored proc, which I inherited from the previous developer, and I wish to fine tune it a bit, because its taking 1.36 mins to retreive 5383 ...
    www.sqlservercentral.com/Forums/​Topic484869-338-1.aspx
  2. When a stored procedure has many steps and many possible different branches, it often becomes difficult to debug. This is especially true if you are building a ...
    www.tek-tips.com/faqs.cfm?fid=4314 - Cached
  3. Stored Procedures - What is stored procedure? A program running in the database that can take complex actions based on the inputs you send it. Using a stored ...
    www.geekinterview.com/question_details/​15688 - Cached
    More results from geekinterview.com »

  4. Stored procedure - Wikipedia, the free encyclopedia

    A stored procedure is a subroutine available to applications that access a ... Extensive or < B>complex processing that requires execution of several SQL statements is ...
    en.wikipedia.org/wiki/Stored_procedure - Cached
    More results from en.wikipedia.org »
  5. Now I can map the stored procedure to that Complex Type using a Function Import. As I showed in my recent post, ...
    thedatafarm.com/.../a-big-step-for-​stored-procedures-in-ef4 - Cached
  6. Stored procedures can offer performance gains when used instead of ... and also how to create simple as well as complex stored procedures that accept and return ...
    www.devarticles.com/.../SQL-Server-​Stored-Procedures-101 - Cached
  7. 3 Triggers, Packages, and Stored Procedures. ... it is recommended that you re-write large or complex stored procedures in a more modular way so that each stored ...
    docs.oracle.com/html/B16022_01/ch3.htm - Cached
  8. Unfortunately, far more complex stored procedures have been written, Bryan, but I will walk through it quickly.
    www.sql-server-performance.com/2003/​stored-procedures-bas -     Cached
  9. This permits you to move the code of a more complex stored procedure into a function. As you can see in the example, you can define a primary key for your return table.
    www.sommarskog.se/share_data.html - Cached
  10. i\'m looking for good books and tutorials about writing comple x stored procedures along with common tricks and best practices commonly used by DBAs.
    stackoverflow.com/...how-to-write-​complex-stored-procedures - Cached