Problem Statement: We are having a legacy application with backend as SQL Server. Till now, we did not face any issues in passing non-unicode values. Now, we are getting unicode characters from user interface. The unicode character is getting passed as given below, in UI. These data are being inserted into table. Currently, we pass unicode characters like below and
Tag: parameter-passing
How do I parameterize table & column in a Postgres-custom-function, selecting PK if value exists, otherwise insert it and return PK anyways?
Trying to do what I specified in the title, I already got the upsert-functionalities working, however when I try to parameterize it, I’m just out of my depth and can’t debug it. My query: now when I try to use the function, I get: What puzzles me about this is the fact that this syntax works fine in an unparameterized
Need to add double quotes to SQL SERVER string values
I have integer values that are being passed from a parameter that needed to be input as a string and padded so that they are 7 digits. This will then be passed into another query. This codes sets @control_num as (‘0005675, 0045464, 0002323’). I need this to be passed as (“0005675”, “0045464”, “0002323”). I’ve looked at other examples on-line but
Pass Minus Values for a SP
I need to pass a value for a SP by multiply it by -1. This is my query and I want pass the quantity by multiply it by -1. Is there any way to do this? Answer change your fist query to negate the sign @Quantity = -qty OR multiply it by -1
SET parameters to microsoft SQL server to set environment
I have created some microsoft SQL server queries to insert values into some of my tables created. Below are the sql queries i used. Above is a piece of code which i have used for dev environment. Same code with prod instead of dev should be used for production. Is there any way to parameterize dev and prod to achieve
How to create SSRS report that use different aggregation algorithms on the same column? [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 2 years ago. Improve this question I’d like to create a report that has columns like Year, Month, Earnings. From Month Jan. to Sept, the report
passing parameters to a stored procedure in C#
How can i send three parameters a to stored procedure in sql? Here is my error: Procedure or function GetIslemIdleri has too many arguments specified. This is my stored procedure: CREATE PROCEDURE …