• 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.

    ITKE440,495 pointsBadges:
  • How to use SQL Server 2008 hierarchyid data type

    SQL Server 2008 offers the new hierarchyid data type – an improved method for storing and querying data. Stored procedures can dynamically find their way up the employees' management tree but they make for complex, resource-intensive queries. With the hierarchyid data type in SQL Server 2008, a...

    Denny Cherry67,555 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...

    ITKE440,495 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 Vaughan4,960 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...

    ITKE440,495 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...)

    ITKE440,495 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?

    ITKE440,495 pointsBadges:
  • Stored procedures: Create and delete constraints and indexes

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

    ITKE440,495 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.

    ITKE440,495 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,590 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.

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