Questions tagged as 'sql-server'

Tagged questions
1
answer

Help with query creation task schedule

Galera, I am making a script to trigger a message according to the record recorded in the database. It's like a CRON task. I have the following record I'm going to put a PHP page in the CRON task of Cpanel, but how can I make a query...
asked by 22.06.2017 / 14:55
2
answers

Inner Join Database

I'm using this command in sqlserver: SELECT ALUNOS.NOME, DISCIPLINAS.NOME AS DISCIPLINA, MAX(NOTAS.NOTA) AS MEDIA FROM NOTAS INNER JOIN ALUNO_DISCIPLINA ON ALUNO_DISCIPLINA.identificacao = NOTAS.codAlunoDisciplina INNER JOIN DISCIPLINAS ON ALU...
asked by 18.06.2017 / 20:18
3
answers

Select first place first half only - SQL Server Code

I made this code for SQL Server to select how many times the pilot "AsdoVolante" came first in the first half of 2017. However, it does not work. What could be wrong? SELECT P.Data, Nm.Nome, epp.PosicaoFinal FROM Prova P, Piloto Nm, EquipaPart...
asked by 11.06.2017 / 02:45
1
answer

Question for SQL Server - Code [closed]

What are the names of the riders who did less than 1:12 on the 1st lap of the 2nd race? How can I make lap times? Will I have to make a new table? The SQL Server tables created were as follows: CREATE TABLE Carro( IdCarro INT NOT...
asked by 10.06.2017 / 16:28
1
answer

SPLIT_STRING in several 'paragraphs'

I'm trying to pick up this type of table: In which I have a daily import for a dbo, I have now had difficulty doing the split_string of the comments, doing the respective cross with the ID. The idea is to have as many rows as (Additiona...
asked by 09.06.2017 / 00:17
1
answer

INSERT with information from a database inside another C #

I'm trying to make an application where I can back up multiple banks at the same time by putting bank information (which will be backed up) within a bank that will allocate this information. But I can not put the information through a syntax...
asked by 09.06.2017 / 21:24
1
answer

SQL Server Code for Question

After 1 hour back from this question I can not solve the code for it. Can someone help me? Question: "Please indicate the number of riders for each car brand" The SQL Server tables created were as follows: CREATE TABLE Carro( IdCarro INT...
asked by 10.06.2017 / 01:43
1
answer

Limit and Offset for web paging in SQL Server

I'm working with PHP and I have about 8000 records currently in DB. As it is for a web page, I need to make a pagination to be viable reading the data. As I understand it, I have to do something similar to limit and offset to...
asked by 28.11.2016 / 13:35
0
answers

Dynamic search like php and SQL Server does not work?

I'm having problems with a part of the code ... I have 5 fields to be searched with input, and they make a call in the database and complete with their data ... But of these 5 fields, 2 are not bringing any results! Please help me !!! S...
asked by 06.06.2017 / 19:42
0
answers

Exception when accessing web service in application Xamarin.forms

I'm creating an application with Xamarin with Visual Studio 2017. I did all the tests in the web service and it accesses the database and records everything perfectly in the browser version. I have now made an implementation in the Xamarin appli...
asked by 06.06.2017 / 16:08