Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var updateOpMgrSql = edge.func('sql',{
- connectionString: GM_CONNECTION_STRING,
- source:function () {
- /*
- exec sp_III_UpdateOperMgr @quoteNumber,@poNumber
- */
- },
- });
- var updateOpMgrSql = edge.func('sql',{
- connectionString: GM_CONNECTION_STRING,
- source:function () {
- /*
- exec sp_III_UpdateOperMgr @quoteNumber=@quoteNumberParam,@poNumber=@poNumberParam
- */
- },
- });
- updateOpMgrSql({ quoteNumberParam: 10, poNumberParam: 15 }, function (error, result) {
- if (error) throw error;
- console.log(result);
- });
- create procedure [dbo].[p_Test]
- @p nvarchar(max) = null
- as
- begin
- select * from [registration].[User]
- where UserName = @p
- end
- var getUser = edge.func('sql', function () {
- /*
- exec [dbo].[p_Test]
- */
- });
- getUser({p:'SomeUserName'}, function (error, result) {
- if (error) throw error;
- console.log(result);
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement