News Articles SQL server

Sending multiple values to stored procedure and use it in IN operator

I’m trying to create a form where user could change some data in the database and there are few things he needs to provide, this is how the procedure looks ALTER procedure [dbo].[ChangePrice] ( @type int, @quality nvarchar(1000), @dim1_from decimal(10, 2), @dim1_to decimal(10, 2), @dim2_from decimal(10, 2), @dim2_to decimal(10, 2), @od_from decimal(10, 2), @od_to decimal(10, […]

The task is to import excel file using procedures. I want to call the stored procedure(works for single row) with PHP code. How Can I do this?

This is from the Query Builder $result = DB::table(‘tablename’)->insert($dataset); This is what I am trying $result = DB::update(‘exec SaveTestItem ?,?,?,?,?,?,?,?,?,?,?,?’, $dataset); SaveTestItem is the name of the procedure that saves one row each to the database. My Question is, Do I need a different stored procedure to save multiple rows or I execute from the […]

How can I save data to SQL Server in Node JS?

I have a NodeJS project that saves data to a Database using a Stored Procedure, I builded this code asking here and watching Documentation from Microsoft the issue is that everytime I run my code using node app.mjs I get the same messages errors: Successful connection Couldn’t insert data: Error: Requests can only be made […]

Having issues with app.post, results in Cannot Get /

I’m trying to create a sign-up page where users can enter information, however, I’m having issues with "app.post" properly working. This is what I have so far: const express = require("express"); const db = require("./dbConnectExec.js") const app = express(); app.use(express.json()); app.listen(5000, () => { console.log(‘App is running on port 5000’); }); app.get("/hi", (req,res) => { […]

Building Secure .NET Apps For IBM i

IBM i is a robust and reliable operating environment. It is still used by many organizations today, especially for data-heavy applications. Read the full story Source: Hackernoon

Why can’t I run a Stored Procedure to save data in Node JS to SQL Server? TypeError: request.callback is not a function

I’m working on a project in NodeJS, this project takes data from a JSON file (I downloaded node-fetch for this) then I put them into an object to then send all the objects into an array and after that save it to a SQLServer DB, the issue that I’m having is that I cannot make […]

How to fetch data from API in Node.js to a view in React.js

I tried to get data from my SQL Server Management Studio. I already made the the query inside API, so when I access those links using postman, it will retrieve data equals to the query inside those links. But when i want to show the data at page, it not comes out even though it […]

How to wait for a file to download from a SQL Reporting Service Access URL?

React developer here! I’m using URL Access for SQL Reporting Services and I’m obtaining my report file in PDF format, right now when the user clicks on this button the file is downloaded, but I haven’t found a way of knowing when the file is completely downloaded and with this info hide the loading message […]

How to pass blob value through ajax call in javascript?

We are Generating blob value and want to get it inserted into the database through SQL Server. We are able to pass the blob value and through the help of Ajax call we are trying to get it to insert but we are receiving the error "Uncaught (in promise) TypeError: Failed to execute ‘array buffer […]

Trying to loop through multiple insert queries in nodeJs but coming across the following error ‘There is another request in progress.’

This is my code var config = require(‘../dbconfig’); const sql = require(‘mssql’); const postDescription = (req, res) => { console.log({ message: "API Working",data:req.body}) var sqlConn = new sql.ConnectionPool(config); sqlConn.connect().then(function () { var transaction = new sql.Transaction(sqlConn); transaction.begin().then(function () { var request = new sql.Request(transaction); const contacts = req.body.recipients.split(",") results = [] contacts.map(i=>{ results.push(request.query("Insert into logtable […]

How to Connect Socket io with SQL Server for real time communication

I’m Working on an App where I need real-time communication. I have Used React JS for frontend Technology and Node, Express JS, and my database is MsSQL. I have 3 User Pannel where every person’s mail is unique and call status query is unique. first of all 1st user received a call if 1st user […]

Add class and onclick function to html string from sql server

I’ve a query string to create html row SELECT(SELECT’Court 1′ as th,’Court 2′ as th,’Court 3′ as th,’Court 4′ as th FOR XML raw(‘tr’),ELEMENTS, TYPE) AS headertr and the output is <tr><th>Court 1</th><th>Court 2</th><th>Court 3</th><th>Court 4</th></tr> is there any way to add an onclick function and class from sql itself? Source: JavaSript – Stack Overflow

We need Roslyn for SQL!

Code review and other quality assurance methods are incredibly useful tools that can be facilitated by Roslyn which is not available for SQL, though it should. Read the full story Source: Hacker Noon – Programming

how to implement get and post method with socketio in node js and mssql

i want to real connection in my app. sent a query with socket io into database in node js and react application. Basically i wanna implement a get and post method with socket io with Mssql Database in node js and react app. anyone please help me to implement this. Source: React – Stack Overflow

how to implement get and post method with socketio in node js and mssql

i want to real connection in my app. sent a query with socket io into database in node js and react application. Basically i wanna implement a get and post method with socket io with Mssql Database in node js and react app. anyone please help me to implement this. Source: React – Stack Overflow

how to implement get and post method with socketio in node js and mssql

i want to real connection in my app. sent a query with socket io into database in node js and react application. Basically i wanna implement a get and post method with socket io with Mssql Database in node js and react app. anyone please help me to implement this. Source: React – Stack Overflow

How to implement get and post method with socketio in node js and SQL Server?

I want to real connection in my app. Sent a query with socket io to the database in node js and react application. Basically I want to implement a get and post method with socket io with a SQL Server database in node js and react app. Can anyone please help me to implement this? […]

Use local photo files from the database to the React.js project

I want to add product data from the database to the React.js project, but the photo cannot be loaded. I put the photo address locally in the database. enter image description here Source: React – Stack Overflow

Sitemap | Terms | Privacy | Cookies | Advertising

Senior Software Developer

Creator of @LzoMedia I am a backend software developer based in London who likes beautiful code and has an adherence to standards & love's open-source.