Questions tagged as 'sql-server'

Tagged questions
0
answers

Doubt over virtual directory usage in IIS and filetable

I need to store files in a FileTable . As I do not know the local path where the files that are in FileTable are, map the network path of the FileTable directory, and thus access the FileTable directory. I need to h...
asked by 15.12.2014 / 16:44
1
answer

Can I add tables of content in the same database as the users? ASP.Net identity

I created an ASP.Net MVC 5, EF 6 project with individual accounts. The database is automatically generated with 5 tables: AspNetRoles ASpNetUserClaim AspNetUserLogins AspNetUserRoles AspNetUsers Is it good practice to put more...
asked by 05.04.2014 / 03:30
1
answer

Using SSIS to fix extra column error

I'm starting to learn about SSIS, I already know how to import a Flat File into the Bank, however I have a problem, the delimiter used is the Pipe "|", and in one of the columns it is used as value. When importing an extra column is "generate...
asked by 06.07.2017 / 21:26
2
answers

How to get the difference in seconds with Sql Server

I know that to get the difference of seconds between Start and End is like this: Case 1: DECLARE @TB_DIFERENCA_INICIO_FIM as table ( ID int, DataInicio datetime, DataFim datetime ) INSERT INTO @TB_DIFERENCA_INICIO_FIM VALUES (...
asked by 19.10.2018 / 23:35
1
answer

Run an XMLA query using WebApi from C #

My WebApi in C # is like this. using Microsoft.AnalysisServices.AdomdClient; using System; using System.Data; using System.Web.Http; using System.Xml; namespace FastReport.WebApi.Controllers { [RoutePrefix("FastReport")] public class...
asked by 10.07.2018 / 16:12
1
answer

INSTEAD OF (Deleted table)

I'm having trouble creating this trigger: CREATE TRIGGER TGmonitoraClientes ON TB_CLIENTES INSTEAD OF DELETE AS BEGIN UPDATE TB_CLIENTES SET clienteAtivo = 0 FROM TB_CLIENTES WHERE CODcliente = deleted.CODcliente INSERT INTO LogClie...
asked by 20.10.2016 / 19:51
1
answer

My SQLServer Express 2014 does not show all installation options

I formatted the PC and I'm trying to install SQLServer Express 2014 with a tutorial on youtube, but when it arrives at that point of my installation, it does not come all the same as the video. Note: I have already installed once and simp...
asked by 12.10.2016 / 19:42
1
answer

Check frequency of records in the table

I have a table where all services performed on several cars are saved. The key is the car license plate. A car can have more than one service a day. And for each service performed a new service id is created, even if it is for the same car. I...
asked by 23.11.2017 / 20:06
1
answer

TimeOut Android and SQL Server connection using JDBC / JTDS

I would like to limit a time for the connection. Whenever it does not find Host to connect, it keeps trying and slows down. Here is the code: @SuppressLint("NewApi") public Connection CONN() { /*Properties props = new Properties(); props.s...
asked by 28.11.2017 / 21:45
2
answers

How to put ISNULL in Subselect with case?

How do I instead return Null return as Não . I'm in doubt about using ISNULL within Subselect along with the case. Result: Projeto teste Null Projeto OK Sim. Instead of Null want to return...
asked by 26.07.2017 / 16:23