Questions tagged as 'sql'

Tagged questions
1
answer

Can you execute an SQL query with another "collation"?

I have a database in which all the tables have the collation: utf8_general_ci and I want a SELECT query to be executed with the collation: utf8_spanish_ci Is it possible without modifying the tables? Can it be with standard SQL? How? The p...
asked by 01.11.2018 / 14:01
2
answers

Slow query MySQL

If you could give me a hand. I am trying to perform a query to get a count of records that are in the activated table that belong to the point of sale 2 and at the same time the total of their records in number, but it takes up to 45 seconds i...
asked by 01.11.2018 / 18:13
1
answer

Add values of two different tables according to the selected id

I have the table "inventory_ticket" this has quantityTicket, and the table "inventory_list", what I want to do is a query that allows me to add the amounts of the two tables but according to the id that is set as fk_inventory in "inventoy_Ticket...
asked by 01.11.2018 / 18:20
1
answer

Do a Trigger updating a field with UPDATE and with DELETE

I have a table called City: CREATE TABLE dbo.Ciudad( Id varchar(36) NOT NULL, DptId varchar(36) NOT NULL, Nombre varchar(40) NOT NULL, Version Timestamp NULL, CreatedAt datetimeoffset NULL DEFAULT...
asked by 26.10.2018 / 21:28
1
answer

Assign positions to convert to a decimal

Good day to all, I hope and you can help me because I can not move forward. I have a checklistbox that is filled with sp and activated by checkbox, the sp brings me the following values: Text SwitchId S...
asked by 26.10.2018 / 20:17
1
answer

Fatal error: Call to a member function query () on null when making a query

I'm trying to do a project with php and mysql in MVC. but I get this error when I want to ask a question. The code of the connection and the query is the following: <?php class dbNBA{ private $host="localhost";...
asked by 24.10.2018 / 05:19
0
answers

Failed to restore SQL Server 2014.Bak file, send "is terminating abnormally" error

I have a development in visual studio that makes backups of the database of a SQL Server 2014 Standard Edition server, after making the backups there is a routine to be able to compress them and leave them as .Gz files: The backups are made w...
asked by 23.10.2018 / 19:22
0
answers

SQL connection to database with c # (question about hosts)

I was interested in connecting an application in c # .net to a mysql database, I am using the referecias offered by the official mysql page, in this case the following one. using MySql.Data.MySqlClient; I have tried different hosts to host...
asked by 13.10.2018 / 03:35
1
answer

Problems with my Store Procedure, do not insert values with json

I have a problem with an SP, what happens is that when you run it, it receives a json as a parameter, and when it is executed, it returns a false message as an error message, this is my code, I am not Very much in this since I am learning: CRE...
asked by 10.10.2018 / 23:43
1
answer

Daily exports in SQL Server Express

I have the following query, I have previously made several information exports from SQL Server Standard or Enterprise, when these versions of SQL have been I have not had much problem since the SQL Server Agent is the ideal tool to do it through...
asked by 16.10.2018 / 19:36