For example, there is a table int type int number int value How to make that when inserting a value into a table indexing started from 1 for different types. type 1 => number 1,2,3… type 2 => number 1,2,3… That is, it will look like this. type number value 1 1 – 1 2… Read More MS SQL How to field add auto increment dependent on another field
I know it is possible to add comments to select statements as follows: select /*my comment*/ id, name from myTable; But is it possible to make this comment more flexible and dynamic? for example, I want to add the bellow variable as a comment in a select statement in a procedure. set @mytext = ‘a… Read More Add a generated comment in select statement of mysql
lo que pasa es que estoy tratando de hacer un package en oracle, pero me sale un error en el begin al momento de crear el procedimiento, he investigado el error que me sale el cual es: PLS-00103: Se ha encontrado el sÃmbolo "BEGIN" cuando se esperaba uno de los siguientes: Pero en internet no… Read More Error en begin al querer crear un package con procedimiento
I finally got this function to work correctly until I tried to implement in a production state. When I run this procedure and call, I am only getting a value for the LowerLimit output and a NULL for the UpperLimit output. I added a SELECT in the procedure that shows the results for both the… Read More SET Command Appears to be Ignored in MySQL Procedure
I’m requesting data from an API that requires paging records based on a custom header called "cursor". Only 100 records may be retrieved per call and as such I’ve created a while loop to execute. The loop functions… until it doesn’t. Once all records are paged, the headers get dropped and my program errors out… Read More How to handle "The given header was not found" when paging records in c# API GET request?
I have a dynamic query in my PostgreSQL function: execute format(‘select something from %’, table_name) I want to run some code for every record returned by the above statement. How can I do this? My first idea is as follows. I need to do something like this: execute format(‘select something from %’, table_name) into my_data;… Read More How to execute a piece of code for each element of the result of a dynamic query in PostgreSQL?
I’m trying to execute the below code to update tables but cannot get the count(*) result in CNT variable. How can i get the number of record in the tables before my update please ? The error i get executing the below code : Error report – ORA-06502: PL/SQL: numeric or value error: character to… Read More Select count(*) IN ORACLE
When I do this update fasta_users set balance = balance + 7000 where id =1; it works fine, No challenge, but when i want to work on it programmatically, it tells me amount has to be a column, i do not understand why it behaves so. My code looks thus : app.put(‘/api/v1/user/fundWallet’,async function(req,res,next){ try {… Read More Having Challenges with Node.js Update SQL for Arithemetics
How to use Transaction in C# Code On Procedure? >Solution : You can do something like this using ADO .NET: SqlConnection con = new SqlConnection("YOURConnection"); SqlCommand command = new SqlCommand("your procedure",con); con.Open(); // this is a class you can use in order to manage transaction in C# for MS SQL // start scope SqlTransaction trans… Read More Transaction in C# On Procedure
I can’t find an option to activate Basic Auth on THTTPClient. My main "issue" is that the first request response with a HTTP/1.1 401 Unauthorized and it triggers an auth event. I want to do it on the first "try". Here is my code: uses System.Net.HTTPClient, System.Net.URLClient, System.NetEncoding; procedure DoRequest(const url, username, password, filename: string);… Read More How to activate/force Basic Auth on THTTPClient