Questions tagged as 'sql-server'

Tagged questions
1
answer

Is there any way to slow down or streamline this VIEW? MSSQL, own software using ASP.NET [closed]

AS WITH Grupos AS(SELECT contato.IDContato, contato_Grupos.IDGrupo, contato_Grupos.IDContato AS IDContexto FROM contato, contato_Grupos WHERE (contato_Grupos.IDGrupo = contato.IDContato)), Membros AS (SELECT contato.IDContato, contato_Grupos.ID...
asked by 05.09.2016 / 16:36
1
answer

Search by age in field of date of birth

Hello, I have a patient table and I need a query in which the user informs an age and returns the existing records. However I do not have the age field in the table but rather date of birth.     
asked by 11.05.2015 / 20:00
1
answer

Write to DB without mask applied by jQuery

I'm doing a project in MVC and with the use of jQuery I made the CPF mask as below: $(document).ready(function() { $(".cpf").mask("999.999.999-99"); $(".cpf").addClass("form-control"); }); Follow my div : <div class="form...
asked by 06.05.2017 / 18:17
1
answer

Doubt in Procedure

Personally I did a function in SQLServer which does control a graph for me in C #, this function brings me all the students from a referring school. The function is as follows: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO...
asked by 24.04.2014 / 16:47
1
answer

SQL server 2014 installation error

Good evening everyone! I'm trying to install sql server 2014 express, but at the time of installation the following errors happen, what can it be? Thanks LOG The error log is this. I'm sorry if you have any other way to send this er...
asked by 05.11.2016 / 04:45
1
answer

summation query

I'm having a kind of problem with this Query, but what I want to happen is for all values like: Goals Scored , Assists Made , Key passes etc, only once. SELECT s.[Statistics ID], s.[Player ID], s.[Game ID], s.[Season ID],...
asked by 19.01.2015 / 18:55
2
answers

Search for elements with a certain distance of time (only reporting the time)

Detail sqlserver (2008) Good night, I have the following problem. I tried searching all day and found nothing. -I need to find elements in a same table that have the same date (day, time ...) and a time distance of at most 40 seconds from one to...
asked by 09.11.2018 / 22:08
1
answer

NODE.JS 'ConnectionError with MSSQL

This is the first time I work with javascript and node.js. I have no idea what the error might be and how to make the connection, my problem initially came up here: link . I have the following simple code that connects a node server to a...
asked by 23.10.2018 / 22:32
1
answer

Application without access to the database after publishing in Azure

I posted an Asp.Net Core 2.1 application in Azure, did the Migrations, the database and tables were created normally, I can see the whole structure of the database by VS, but the application does not access the database. Cananyonetellmewhatm...
asked by 25.10.2018 / 04:28
1
answer

Sql server convert String time to Decimal

I have a question about how to convert a string column that returns the time as '08: 00: 00 'to decimal, exactly as Excel does, when changing the format to numero for example: '08: 00: 00 '=' 0,33333333 ' Thank you in advance     
asked by 18.10.2018 / 22:52