/* GET single comment. */ router.get('/:id', function (req, res) { var conn = db.createConnection(); var request = db.createRequest("select * from comments where id = @id for json path, without_array_wrapper", conn); request.addParameter('id', TYPES.Int, req.params.id); db.stream(request, conn, res, '{}'); });
agent.endTransaction() }) request.addParameter('value', tedious.TYPES.Int)
{ key: `revision${rowId}`, value: event.metadata.revision, type: TYPES.Int }, { key: `event${rowId}`, value: JSON.stringify(event), type: TYPES.NVarChar, options: { length: 4000 }}, { key: `hasBeenPublished${rowId}`, value: event.metadata.published, type: TYPES.Bit }
request.addParameter('revision', TYPES.Int, revision); request.addParameter('state', TYPES.NVarChar, JSON.stringify(state), { length: 4000 });