Lately i'm going deep in MongoDB and i'm wondering about the stored JavaScript Procedures. After reading the Blog Entry from PointBeing, i got some questions.   Is it a real advantage to store my code in DB? I mean functions like lookups for...
I am trying to check if there are duplicates in a collection. New to stored procedures and azure database, so for now am trying to count distinct entries. If count distinct (column name) = count (column name), there are no duplicates, so I am trying...
Trying to return table from PLV8 stored procedure.  It fails to recognize input args i.e. $1 when the function is with  RETURNS TABLE(...).  It works when function returns scalars:  psql# CREATE OR REPLACE function foo(integer)        RETURNS integer...
I am trying to write a stored procedure with a Merge statement.  It looks something like this:  create or replace procedure database.events.insert_groupss() returns string LANGUAGE JAVASCRIPT as $$ var sql_cmd = 'Merge into database.events.groups...
as a total JavaScript beginner, how do I actually develop for it? I mean, I've seen https://azure.microsoft.com/en-us/documentation/articles/documentdb-programming/ but there was no mentioning of a development environment.  Is there something lik...
I currently have a working process where an ajax call is made in my blade which makes a call through the controller and that function hits a stored procedure call using PDO. This call is successful and my stored procedure executes/inserts properly an...
In a DocDb stored procedure, as the first step in a process retrieving data that I'm mutating, I read and then use the data iff it matches the etag like so:  collection.readDocument(reqSelf, function(err, doc) {     if (doc._etag == requestEtag)...
I have a javaScript script that is not web related and need to run a stored procedure that contains a raise error statement, and make sure that the procedure was successfully run.  If I just do,   function runSQL() {     var rs = new ActiveXObject(&#...
I'm trying to execute a stored procedure via a remote method on one my models.  I'm able to execute very basic selects via custom SQL that utilize a single parameter, but can't seem to get an around an error passing multiple arguments int...
I'm trying to run a SQL Stored Procedure called UpdateKey that saves a record called Key into the Kiosks table of my database (called MyDB) based on record ID, and then returns it, as below:  USE [MyDB] GO  SET ANSI_NULLS ON GO SET QUOTED_IDENTIF...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.