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

    ITKE344,955 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,045 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...

    ITKE344,955 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?

    ITKE344,955 pointsBadges:
  • Stored procedures: Create and delete constraints and indexes

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

    ITKE344,955 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:
  • Undocumented stored procedure: Return string type for a column with sp_gettypestring

    One useful (albeit unsupported) stored procedure in SQL Server 2000 is the sp_gettypestring, which can be used to return the type string for a column in a table.

    SearchWindowsServer1,985 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 Cherry66,070 pointsBadges:
  • Stored procedures: Find columns and tables

    Continuing our stored procedure series, this simple routine is handy for finding columns by name and listing the table(s) in which they exist. The listing includes table name, column name, ordinal position, data type, data size, width/precision and scale.

    ITKE344,955 pointsBadges:
  • Q&A: Writing stored procedures in SQL Server 2005

    When writing stored procedures in SQL Server 2005, you have options beyond T-SQL. Contributor Serdar Yegulalp explains the benefits of writing stored procedures using CLR and how to convert existing stored procedures to the CLR model.

    SearchWindowsServer1,985 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.