473,569 Members | 2,929 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1858
(mm**********@g mail.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****@sommarsk og.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1903
by: sh | last post by:
Hi. I am quite new into stored procedures written in t-sql. (MSSQL server) I have three different tables in my DB. Two of the tables (with different data) are updated regularly and need to be joined into a third table that works as the basis for an application in ASP. The two former tables each contain a field with a persons identity...
2
1985
by: Miles Ashton | last post by:
A common request for enhancement to applications is to "make this field bigger". I know I've been caught with increasing a field size, and then spending hours debugging because another stored proc has a variable or temp table that uses the field defined as the original varchar size. SQL Server just truncates to fit the data into the smaller...
2
1439
by: zMatteo | last post by:
I've a problem. In my MSSql db I've some tables named username.mytable and only one store procedure named dbo.sp; CREATE TABLE . ( NOT NULL , NOT NULL ) ON
0
2393
by: ipoxygen | last post by:
Hi, I do have 6 identical tables on six different databases (same server). I would like to merge them into one single table for reporting purposes. For the majority of the table it does work without a problem with following procedure: /* 100: NL 200: BE 300: UK 400: FR 600: SP
9
3853
by: weirdwoolly | last post by:
Hopefully someone will be able to help. I have written a stored procedure in C++ called from a Java test harness to validate the graphic data types in C++ and their use. I have declared the vargraphic input parameters along the following lines in i_vargraphic100 vargraphic(100) and they are populated from String's in java.
0
3643
temat
by: temat | last post by:
Hi i got a problem when i try to Alter Table in the procedure. I have red that i need to place keyword IMMIDIATE but it dont work in mssql. I need thede procedure to drop FOREIGN KEY, TRUNCATE and add FOREIGN KEY -- PUBLISHERS ALTER PROCEDURE clearPublishers AS BEGIN TRANSACTION ALTER TABLE dbo.Books DROP CONSTRAINT...
4
3373
by: aCe | last post by:
hi all, i need to convert these simple PHP code into stored procedure : <?php $result = mssql_query( "SELECT whid, whcode FROM warehouse" ); while( $wh = mssql_fetch_object( $result ) ) { $result = mssql_query( "SELECT plid, nopl FROM packlist WHERE whid = '" . $wh->whid . "'"; while( $pl = mssql_fetch_object( $result ) ) {
3
2366
by: ckauvar | last post by:
The PHP below calls a stored procedure in a MSSQL database when I am using SQL in a Windows environment. I've recently switched to a UNIX environment and am now using ODBC (via FreeTDS) to connect to the MSSQL database. I need to rewrite the PHP below to use the odbc_connect terminology instead of the mssql_connect terminology. Can anyone...
4
6038
by: vijjibalu | last post by:
Hi all, as part of my project requirement we are migrating procedures from mssql to mysql below is the code in mssql CREATE PROCEDURE TABLE_DEPEND_INSERT_ORDER AS CREATE TABLE #TABLE_DEPEND_ORDER_SUMMARY ( TABLE_NAME varchar(128), SORT_ORDER int )
0
7707
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7933
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8142
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7688
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7989
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5517
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3663
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1232
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
964
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.