Questions tagged as 'sql'

Tagged questions
0
answers

How can I delete tables from another database connection in laravel with php artisan migrate: fresh

I am working on a system where I need to connect to two databases, I was able to generate the connection so that at the time of migrations, I generated the tables in their respective database. My problem starts when I try to delete them and m...
asked by 21.05.2018 / 19:04
0
answers

INSERT in SQLSERVER with DELPHI XE4

I am new to Delphi XE4 and can not find where my error is in the query: INSERT into CUENTAS (codigocu,nombre,apellido,idcondiva,email) values ( :icodigocu, :inombre, :iapellido, :iidcondiva, :iemail); The error that shows me is this: dbex...
asked by 05.05.2018 / 20:58
1
answer

Change value of an SQL column

I am doing a project in laravel and MYSQL, I would like to know if there is any way that if the stock is different to 0 the state becomes 'not available', in case there is no MYSQL, there is a manager of DDBB that allows me?     
asked by 05.05.2018 / 21:16
0
answers

How to do folder jumps to open an .sdf file in C # and that does not affect when changing the computer program?

Hello, recently, I and a university colleague had to deliver a project, and we always had the same problem to open the database, because when changing computers, the route was different. The teacher told us to do so that with ../../ we could...
asked by 12.05.2018 / 15:31
2
answers

Select a list of two common related elements in sql with entityFramework and linq

I have a list of people that are related to a committee table and another table types person, I need to return the list of people of a committee and also return the list of people of a type note: return the people that I return from the relation...
asked by 27.07.2018 / 19:29
0
answers

Unexpected end of JSON input

Good I have the following problem when bringing information from the database, I am making an AJAX request when loading the DOM so that it brings me all the videos from the database and shows them on the homepage. For this I have the following c...
asked by 02.05.2018 / 05:27
0
answers

Trigger error SQL 1242 (Reserved words NEW & OLD)

Next I am going to attach an image about the database on which I am working to perform the trigger and I begin to tell you Well, the idea was to create a trigger that, when I put all the data in an order, gave me the subtotal, with the fol...
asked by 03.05.2018 / 12:51
0
answers

How to get two variables that have expressions in SQL

Someone could help me in this, I have problems in How to get in two query two variables that have expressions in SQL, in this case the image would be the number of projects with status 2 and number of projects with status 3. Thank you    ...
asked by 11.05.2018 / 15:52
1
answer

Know what permissions a user has in SQL Server?

I have a user that only allows me to make queries in SQL but I need to know by means of a query what permissions this user has in SQL Server.     
asked by 11.05.2018 / 16:53
0
answers

Update table when both conditions are met

I have the following query: UPDATE sm4rtuniversity.badges_members SET active = 'si' WHERE user_id IN (SELECT m.id FROM skill s INNER JOIN skill_rel_user sru ON s.id=sru.skill_id INNER JOIN user u ON u.id=sru.user_i...
asked by 27.04.2018 / 21:41