Questions tagged as 'sql-server'

Tagged questions
1
answer

Can you connect an Android Xamarin App, to sql server directly or is it necessary to consume some WebApi or some other way?

I'm starting in the mobile app, and I have an App that needs to bring all the data from sql server "online", I tried to connect the App to the sql server as if it were a WinForm, and when it is connected to the PC the test smartphone and start d...
asked by 19.09.2017 / 00:17
1
answer

Generate data matrix with LEFT JOINS in SQL Server

Good afternoon ... I have this temporary table with the following structure: create table ##PAC_ID_TEMP ( Id INT PRIMARY KEY IDENTITY(1,1),NHC varchar(30), Id_Ficha_IOS int) CREATE NONCLUSTERED INDEX Idx1 ON ##PAC_ID_TEMP(NHC); Which I use...
asked by 18.09.2017 / 22:07
1
answer

Autocomplete Finder AngularJS + SQL SERVER does not show results

I'm doing a search through a DB in SQL Server and AngularJS where at the time of writing you will be suggesting the results (Google type) The problem is that it does not show me the suggested results, I'm doing it in the following way:...
asked by 18.09.2017 / 20:16
1
answer

Is there a way to view a view query with read-only permissions?

I need to get the query of a database view sql server and I only have read permissions and having only read permissions, the design field is deactivated. Is there a way to see the query without the permissions?     
asked by 12.09.2017 / 16:25
1
answer

Convert Row to Column SQL server query

Good morning, I need to transpose or change the result of a table in the following way: The structure of the table is 5 columns (description of users, permission1, permission2, permission3, permission4) the description field is varchar...
asked by 31.08.2017 / 19:01
1
answer

Query with pivot table - SQL Server 2014

I have 3 tables: Persona(IdPersona(PK), NombreYApellido, IdTelefono); Telefono(IdTelefono(PK), Numero, IdTipoTelefono); TipoTelefono(IdTipoTelefono(PK), Descripcion); To relate them I created the table PersonasTipoTelefono(IdPers...
asked by 07.09.2017 / 17:18
2
answers

How to start SQLEXPRESS 2016 service from console application in C #?

I have the following code of a console application in C # to start the SQLSERVER 2016 service, but I could not, here is the code and the code error. using System; using System.Collections.Generic; using System.Linq; using System.Text; using Sy...
asked by 25.08.2017 / 03:36
2
answers

Convert columns into rows with PIVOT

I have the following query: SELECT COUNT(*) 'Impartidas', DAY(kh.Hora) AS 'Dia' FROM K_Horario kh WHERE CONVERT (char(10),kh.Hora,20) BETWEEN '2017-07-03' AND '2017-07-09' GROUP BY DAY(kh.Hora) ORDER BY DAY(kh.Hora) And it returns the follo...
asked by 15.08.2017 / 21:09
1
answer

SQL Server procedure always returns int

If I run the following code in
asked by 15.08.2017 / 16:19
1
answer

How to update fields by querie of databases of different servers?

Good day, I hope and you can help me. I have 2 databases that are located on different servers, my idea is to update some fields through a query, however they are on different servers, for example I have one base on a server termination 192 ......
asked by 07.08.2017 / 18:43