Re: Output stored procedure

Filips Benoit (benoit.filips@xxxxxxxxxx) writes:
How can I show the resultrecords of a SP.
I can be done by doubleclick the SPname?
But how to do it by code.

I want the following interface
In my form the user
1 selects a SP (combobox showing a userfrinly name)
2 adds the related parameters
3 and then click the show result-button

but the .execute command doen't show teh records.

I don't know what .execute you are using, but I would not expect an
..execute method to display any data on its own, but return data in
some data struction that the application would have to deal with.

I want the same output as you have doublclicking the SPname in the
objectwindow.

What object window? This is nothing I'm familiar with.

To summarise: you need to provide more details on what you are actually
doing. What sort of environment do you have? What client API etc?


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: grant access to extended properties
    ... Do you know anything about this "EXECUTE AS" for 2000? ... I played around with GRANT but apparently, a member of "db_datareader" ... Reading Books Online tells us that to add extended properties, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: the security needed for SET IDENTITY_INSERT
    ... the procedure on db2 first insert data to another Users table (in old ... EXECUTE AS is not good for many reasons. ... Did you read the permissons section in Books Online? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • Re: sql 2005 sms and scripts
    ... and execute it such that all scripts will be executed? ... You can do a FOR loop in a .BAT file which runs the files from SQLCMD. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.programming)
  • Re: Syntax Check
    ... If you're running against SQL Server, you can use "SET PARSEONLY ON|OFF". ... Check out books online for details on PARSEONLY. ... and generates an error if there is a syntax error, ... execute something for real. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)