- I hope my explanation is clear - I have a PHP script that takes a long time to execute, so I decided to run it in the background, what happens is that even in the file that I run the second script, wait until finish this execution to answer. I...
I have a question about an alphanumeric chain, I have to validate that this chain if it has an alphanumeric, for example:
EJEMPLO123+
Delete the% "+" and keep the alphanumeric only.
I am trying to save a string of type date in a field of the database, but when I try to save a date whose day exceeds day 12, it returns the following error:
String was not recognized as a valid DateTime.
I tried to for...
I have a table with the following structure:
ID MONTH
21714 JAN
76101 JAN
175187 FEB
243575 APR
299116 JUN
304742 JUN
I need to generate a string of 14 characters for each record similar to 'ABC00...
I have this code that I started, to be able to connect to my server of SQL Server by means of Python in Ubuntu , all the components of:
server, user, password, base already make sure they are correct.
But when I ru...
I have a table with several fields and my goal is to bring only the id that appear only once and whose fields 3 and 4 are not null (any of them)
The query you make is the following
SELECT id
FROM tabla
WHERE campo3 IS N...
I have the following code which gives me the error shown, it seems to me that I am misplacing some quotes.
Declare '@Cuenta Varchar(25),@Fecha Varchar(10),@Moneda Varchar(3),@User Varchar(20)'
Declare '@NomTabla Varchar(60)'
SET @User...
Already review this question and it's not really what I'm looking for.
You see, I am generating a Sotred Procedure whose query becomes a sales report.
The condition is that, when it comes to specific dates, you must select from some tabl...
When trying to create this query in SQL Managament
SELECT OrderID, ProductID, UnitPrice, Quantity, (UnitPrice * Quantity) FROM [Order Details]
WHERE OrderID < 10260
ORDER BY OrderID
COMPUTE SUM(Quantity) BY OrderId
I do not recognize...
I have a table in SQL that has two fields ( id , xml ), just looking at my XML field, the row is like this:
<Sheet1>
<Production_x0020_Line>L1B4</Production_x0020_Line>
<Item_x0020_Number>VPJG7F-1084...