Viewing 2 posts - 1,411 through 1,413 (of 1,413 total)
Yes exactly. Something like:
drop proc if exists wm.api_comment_post;
go
create proc wm.api_comment_post
@securitystamp uniqueidentifier,
@cw_id bigint,
@comment nvarchar(1024),
@test_id bigint output,
@response nvarchar(max) output
as
set nocount on;
set xact_abort on;
begin transaction
begin try
declare
@awc_id bigint;
insert comments(u_id, w_id, cw_id, comment, created_dt, edited_dt)
select
wm.func_user_id(@securitystamp),
cw.w_id,
cw.cw_id,
@comment,
sysutcdatetime(),
sysutcdatetime()
from
wm.class_workouts...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 24, 2019 at 1:31 pm
Reasons to use output parameters in stored procedures:
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
July 23, 2019 at 1:16 pm
Viewing 2 posts - 1,411 through 1,413 (of 1,413 total)