• Why use stored procedures?

    Stored procedures offer several distinct advantages over embedding queries in your Graphical User Interface (GUI). Your first thought may be: "Why tolerate the added development overhead?" After seeing the advantages, you may change your mind.

    ITKE346,360 pointsBadges:
  • An advantage of using a stored procedure

    Suddenly, in most enterprises, ASP means Application Service Provider. But most programmers still know the acronym ASP as Active Server Page. This tip from Shelley Powers book Developing ASP Components, published by O'Reilly & Associates, looks at the advantages of using stored procedures in...

    ITKE346,360 pointsBadges:
  • Saying yes, no or maybe to stored procedures

    The world of software somewhat resembles a pendulum. Styles of development swing in and out of favor. Take stored procedures, which work to some extent and may sometimes be the shortest way to a successful project.

    Jack Vaughan3,120 pointsBadges:
  • SQL Server stored procedures tutorial: Write, tune and get examples

    This SQL Server stored procedures tutorial covers three areas for simplifying database development. A stored procedure, sometimes called the work horse of the database, also provides an important layer of security between the user interface and database. But the process of grouping T-SQL statements...

    ITKE346,360 pointsBadges:
  • stored procedure

    In a database management system (DBMS), a stored procedure is a precompiled set of Structured Query Language (SQL) statements that can be shared by a number of programs. (Continued...)

    ITKE346,360 pointsBadges:
  • How to view a list of stored procedures through SQL*Plus?

    How can I get a list of stored procedure objects from SQL*Plus? How can I view the source of the stored procedures?

    ITKE346,360 pointsBadges:
  • Stored procedures: Create and delete constraints and indexes

    This collection of six stored procedures will help you create and delete constraints and indexes.

    ITKE346,360 pointsBadges:
  • Stored procedure: Determine last database backup

    You have dozens or hundreds of SQL Servers to administer and you just want to know when the last backup was taken for each database on each instance. This stored procedure will help.

    ITKE346,360 pointsBadges:
  • SQL Server stored procedures vs. CLR stored procedures: Time to migrate?

    Should you use SQL Server stored procedures or CLR stored procedures? Expert Serdar Yegulalp helps you decide which is more appropriate for you.

    SearchSQLServer2,550 pointsBadges:
  • Check SQL Server database and log file size with this stored procedure

    Knowing the size of a SQL Server database is one of the many DBA responsibilities that you can accomplish easily with the stored procedure sp_SDS. Not only will sp_SDS determine "SQL Database Space," but it can also be used to monitor database growth, alert a DBA on data or log file growth, execute...

    ITKE346,360 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following