SQLProcedures won't distinguish between functions and stored procedures

SQLProcedures won't distinguish between functions and stored procedures

This is a discussion on SQLProcedures won't distinguish between functions and stored procedures within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi all, I'm using SQLProcedures to get the list of stored procedures from a SQL Server 2000 database. The ...

		Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC
SQLProcedures won't distinguish between functions and stored procedures

#1 (permalink)

02-27-2008, 10:08 PM

Shannon Cayze

Posts: n/a

SQLProcedures won't distinguish between functions and stored procedures

Hi all,

I'm using SQLProcedures to get the list of stored procedures from a SQL
Server 2000 database. The procedure type is always SQL_PT_PROCEDURE,
even for functions. Is this the expected behavior and Is there a way to
distinguish between the procedures and functions?

Thanks in advance,
Shannon

« How not to use a distributed transaction | Variable SQL Statements pulling from a cell in Excel »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 08:23 PM.