Questions tagged as 'sql'

Tagged questions
3
answers

last record entity C # windows form

Hello I hope you can help me I'm trying to get how many records my sql table has I have the following public int ultimoRegistro() { var LastRecord = (from c in db.Alumnos orderby c.IDAlumno descending...
asked by 09.11.2018 / 23:39
1
answer

Simple SELECT SQL doubt

I have a table with the following records (the fields are Formula - Base): F1 - B1 F1 - B2 F1 - B3 F2 - B1 F2 - B2 F3 - B1 F3 - B2 F3 - B4 What I want is for me to select which formulas contain the bases B1, B2 and B3....
asked by 14.11.2018 / 17:13
1
answer

Show contents of a database with php

I'm doing a job for the school, in which they ask me to do a "mini replica" of what would be twitter, so we can see data handling with php and so on. Well, I have reached the point of registering users, logging in and saving tweets in a database...
asked by 06.04.2018 / 18:49
2
answers

Insert data into related tables C # [duplicated]

I want to store it in a table called movies, where it has a foreign key, gen_id. In the table generos I have populated with 4 genres. Now in C # I have the SQL command step by string but it tells me that there is an error in...
asked by 13.11.2018 / 03:59
1
answer

a group of students can not use that classroom if it is already reserved at that time [duplicated]

I have a problem I do not know how to design the solution. A group of students can not use that classroom if it is already reserved at that time. For example, you can not assign a group to a classroom that is already occupied with a specific...
asked by 04.05.2018 / 09:30
2
answers

How to insert SQL with data from a Query?

I need to insert data into a table in another table. Basically I need to do this: INSERT INTO Consulta (tipo, busqueda1, resultado1, resultado2, resultado3) The value of the field tipo is defined by me, but the values of the other fi...
asked by 03.05.2018 / 22:25
2
answers

Sorting of lists C #

I have a question about the handling of lists ordered in C # I basically have a list like the following 1/02/2018 Capital $800 1/02/2018 Interes $1000 1/02/2018 IVA $160 1/03/2018 Capital $800 1/03/2018...
asked by 09.03.2018 / 23:40
3
answers

How to empty my database from SQL Server [closed]

I would like to know how to empty my database, from SQL Server.     
asked by 29.05.2018 / 15:34
2
answers

Replace characters in column during SELECT SQL

I have a column in my database that goes something like this: ----------------- | nombre | ----------------- | 225/65/17 etc| | 225/55C R17 etc| | xxx225/65 r16 | | 235/65 17 etc| | etc 215/65 R17| ------------- And I...
asked by 15.02.2018 / 10:57
1
answer

Updated PHP - HTML form

I have a form to add data to a table (visual in HTML) and to the database (in a table called "Cabanas"). Doubts: 1) Why is not the table automatically updated when you click "Save"? And you only see the cabin added when we update t...
asked by 29.11.2017 / 10:20