Tuesday, 28 August 2018
Subscribe to:
Post Comments (Atom)
CREATE PROCEDURE TestTVP
(
@param1 int,
@param2 int,
@a int OUTPUT
)
as
SET NOCOUNT ON
DECLARE @T1 as TABLE
(
PK INT IDENTITY NOT NULL,
Wert INTEGER,
Name INTEGER
)
INSERT INTO @T1(Wert,Name) VALUES (@param1,@param2)
return select count(*) from @T1
GO
exec TestTVP '1','22'
OUTPUT
parameterdeclare @z int
exec TestTVP '1','22' ,@z output
return
from Stored Procedure make it only...
select count(*) from @T1
Hello Friends! I am Ramana a part time blogger from Hyderabad.
0 comments:
Post a Comment