469,291 Members | 1,783 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,291 developers. It's quick & easy.

How to find out what type of the data procedure in MSSQL 2005returns?

How to find out what type of the data procedure in MSSQL 2005
returns?
Using inquiry about sample.

Example:

SELECT paramtypes FROM sysprocedures;

Result:

integer
row
clob
array list
array
......

Thanks,

St. Mr
Oct 13 '08 #1
1 1649
(mm**********@gmail.com) writes:
How to find out what type of the data procedure in MSSQL 2005
returns?
Using inquiry about sample.

Example:

SELECT paramtypes FROM sysprocedures;

Result:

integer
row
clob
array list
array
.....
There is not really any good way to do this. One reson is that in theory
the same procedure could return a differently structured result set
every time.

The method that is used by several client APIs is to run SET FMTONLY ON
prior to running the procedure. In this mode, SQL Server just sifts
through the queries, and returns metadata information, but it does not
execute the queries. There are a lot of problems with this scheme. For
instance, temp tables are not created in this mode, which can lead
to error messages about missing tables.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Oct 13 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by zMatteo | last post: by
4 posts views Thread by aCe | last post: by
3 posts views Thread by ckauvar | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.