select reads the stored procedure return set with parameters, finds the read statement

bmw89625x5

Write a stored procedure as follows:
CREATE PROCEDURE dbo.getPauseDays
    @htongInfoIdx int
AS
declare @ p1 binary (16)
declare @ p2 binary (16)
create table # (c1 text)
insert # select ""
SELECT @ p1 = textptr (c1) FROM #
--Declare a cursor
DECLARE tb CURSOR LOCAL
  FOR
  SELECT textptr (pausedays)
  FROM hetongpauseinfo where uidx = @htongInfoIdx
OPEN tb
FETCH tb INTO @ p2
WHILE @@ fetch_status = 0
BEGIN
UPDATETEXT # .c1 @ p1 NULL null hetongpauseinfo.pausedays @ p2
FETCH tb INTO @ p2
END
CLOSE tb
DEALLOCATE tb
select c1 from #
drop table #
GO

In the query analyzer, exec getPauseDays 12 can access the query set, but it doesn't work in the select statement. ． select a. * from (getPauseDays 12) as a read like this will not work

fanfan1980

--A simple example
use pubs
go

create proc pc
as
select title_id from titles

create table T (col varchar (50))
insert T exec pc

select * from T

prajna

The stored procedure contains select ...

bmw89625x5

God, forgive me for being foolish and not understanding what my friends upstairs mean. ． ． I can run this proc in the query analyzer, but in the foreground, I use select to call this proc's recordset. I won't write a statement.

fanfan1980

Execute getPauseDays 12 directly in the foreground

bmw89625x5

Execute directly? How to write ＞? .... and (exec getPauseDays 12) like '% 20005-01-01%' ... This is part of the query. ． I want the recordset returned by it to be judged like, can't run? Checked a lot of information, just ignore it. ． ＞ _ ＜

cxs3214

it's the only way
insert into #t
exec getPauseDays 12

select * from #t

cxs3214

insert into #t
exec getPauseDays 12

This is to insert the result set produced by exec getPauseDays 12 into #t

prajna

There must be a method to execute stored procedures in the connection object in the foreground
It doesn't work, write a function that returns a table type

cxs3214

select * from openrowset ('sqloledb', 'trusted_connection = yes', 'SET FMTONLY OFF; SET NOCOUNT ON; EXEC your database name: getPauseDays 12')

But this is more perverted.You better write a function that returns a table type instead of a stored procedure