Answers
Mar 18, 2009 - 04:01 AM
ALTER PROCEDURE [dbo].[test]
@test1 nvarchar(10),
@somevalue bit
Declare @testid int
if (@somevalue = 0)
@testid = Exec InsertValue
@test1
Alter procedure InsertTest1
@test1 nvarchar(10)
Insert Into Test
(test)
values
(@test1)
RETURN SCOPE_IDENTITY()
@test1 nvarchar(10),
@somevalue bit
Declare @testid int
if (@somevalue = 0)
@testid = Exec InsertValue
@test1
Alter procedure InsertTest1
@test1 nvarchar(10)
Insert Into Test
(test)
values
(@test1)
RETURN SCOPE_IDENTITY()
Mar 18, 2009 - 04:02 AM
Sorry
ALTER PROCEDURE [dbo].[test]
@test1 nvarchar(10),
@somevalue bit
Declare @testid int
if (@somevalue = 0)
@testid = Exec InsertValue
@test1
Alter procedure InsertValue
@test1 nvarchar(10)
Insert Into Test
(test)
values
(@test1)
RETURN SCOPE_IDENTITY()
Apr 09, 2009 - 04:14 AM
The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.
The Quomon Team
The Quomon Team
Apr 09, 2009 - 04:23 AM
no i did not get appropriate answer
consider two procedure
one return like empid, name
and i want to supply empid in second procedure and second
procedure gives the result of first parameter which coming
from first procedure.
note: first procedure returns many rows
in result
we want result(of all records which passes from one procedure) from second procedure.
consider two procedure
one return like empid, name
and i want to supply empid in second procedure and second
procedure gives the result of first parameter which coming
from first procedure.
note: first procedure returns many rows
in result
we want result(of all records which passes from one procedure) from second procedure.
Add New Comment