Stored Procedures

SQLServerCentral Article

Stored Procedure Development Cycle

  • Article

This month Robert covers the process he uses for developing stored procedures. In many ways it reflects how software is developed, but it does have it's minor differences. This is a high level process discussion, not a line by line example of the entire process - by design of course.

You rated this post out of 5. Change rating

2003-09-03

10,919 reads

SQLServerCentral Article

Creating Stored Procedure Documentation with XML, SQL-DMO and XSLT

  • Article

This article introduces TSQLDoc, a Windows Script Host script that extracts procedure metadata and embedded documentation comments from Transact-SQL stored procedures, generates XML documentation for every stored procedure in a database and optionally transforms the XML document into HTML or other format using XSLT.

3 (2)

You rated this post out of 5. Change rating

2002-08-09

15,790 reads

Blogs

Elevate Your Data Leadership: A Unique Intensive Learning Experience

By

I’ve collaborated with two industry experts to design a transformative course for data leaders:...

A New Word:Maugry

By

maugry – adj. afraid that you’ve been mentally deranged all your life and everybody...

Friday Flyway Tips–Capture the Filegroup for Tables

By

A customer asked recently why Flyway doesn’t detect the filegroup for some changes. I...

Read the latest Blogs

Forums

Visual Design for Safety

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Visual Design for Safety

A New Audit

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A New Audit

Forget the Models, Your Data is the Secret Sauce for Generative AI

By Amit Rai

Comments posted to this topic are about the item Forget the Models, Your Data...

Visit the forum

Question of the Day

A New Audit

I have a brand new D: drive on my system that is formatted, but contains no files or folders. What happens when I execute this code?

CREATE SERVER AUDIT audit2 TO FILE ( FILEPATH ='D:\audit' );
GO

See possible answers