Hi, I want to create a variable OUT that I will use later, but the following error appears when creating the block:
DECLARE
@COD_PERI INT,
@COD_ESTA_LOG INT OUT
BEGIN
SET @COD_ESTA_LOG = 5
END
Mens. 102, Level 15, State 1,...
Good evening I have here processes stored in sqlserver and I would like to implement them in postgres , I just need you to please explain what is the output element in postgres and the varable as there are many and it would not be c...
I am using Eclipse Oxygen to develop a Java program and I want to use SQL Server 2017 to save the information. I read in other places how to do it, but, it does not work for me.
Steps I've done so far:
I downloaded the Microsoft JDBC Dri...
My problem is this: I have to make a script in TSQL that if the numbers are less than 50, you must make the root of the sum of its squares, if it is equal to 50, add its squares, and if it is greater than 50, divide the first one between...
Good morning, when inserting a form with PHP if you insert the records in the database but it sends me the following WARNINGS:
Warning: Variable parameter 1 not passed by reference (prefaced with
an &). Variable parameters passed to...
I have the following consultation
SELECT
f.SE_Factura,
SE_Consecutivo_Embarque,
f.SE_Orden_De_Compra,
f.SE_Orden_De_Venta,
f.SE_Fecha_OV,
f.SE_Cliente_Despachar_A,
(f.SE_Peso*e.SE_Cantidad_Embarcada)*400 as Peso,...
I am doing a project and at this moment I need to import data from a CSV file "Excel" Delimited by commas (,) certain information, I need that by means of a form they can upload the excel and that this excel is automatically imported in the tabl...
I need to send the result of my stored procedure from the controller to the view.
This is on my controller:
using (SqlConnection con = new SqlConnection("data source=DESKTOP-99IPRRD;initial catalog=RecursosHumanos;integrated security=True;M...
I'm trying to find the rows that start with Au but the sql server is reporting an error when using the Description with the like it says: Ambiguous column name 'Description'.
Select A.NotesID, Coalesce( A.Description, B.Description ) as Descri...
I'm trying to do update in a DB, but I'm not making the changes to that command. When I do it in the direct query of SQL server it works, but when I do it from my application it does not do the update .
This is the query in SQL Serv...