Questions tagged as 'sql-server'

Tagged questions
1
answer

Database query in C # mvc

How is the syntax or how do I convert a multi-joins query to a search in my application in C # asp.net mvc? Example: I have a form with the following controller public ActionResult Pesquisa(int id = 0) { var resultado = co...
asked by 30.06.2014 / 22:20
1
answer

SQL database online only for LOCAL NETWORK, connect via C #

I developed a system for my company and need a database hosted on our internal network, explaining better I want to host this database on a PC running a Windows Server 2012 here in the company, our connection is all wired .. . It's a network...
asked by 09.12.2014 / 18:38
1
answer

How to force an Exception when trying to delete a Master record that already contains relationship in a Child Registry?

I have created the following structure in SQL Server: UsingEntityFrameworkwithCode-First,theclasseslooklikethis:[Table("Master")] public class Master { [Key] [DatabaseGenerated(DatabaseGeneratedOption.None)] public int Id { get; s...
asked by 18.03.2015 / 16:58
3
answers

Compare 2 tables field by field

I have two tables with equal fields. Table A and B I need to compare the contents of the two tables field by field. I'm using the following code to find the records that have some different field, but I would like it to be shown in the record...
asked by 18.06.2018 / 19:17
1
answer

Update on two SQL Server tables [duplicate]

How do I perform an update at the same time on two different tables? I have a table named Tarefa and another called VinculoReferencia , both have the field Taridinclusao where is this field that needs to be updated at th...
asked by 02.10.2017 / 22:56
1
answer

How to return search regardless of accent on Asp.Net MVC systems [closed]

I have a problem with a system in relation to the search that does not return a result for reasons of emphasis. I would like to know how to make the accent be ignored in the system? Note The system is already hosted and running with SQL Se...
asked by 29.10.2017 / 22:09
1
answer

JOB with 2 steps, first step stops when it reaches 1 minute of execution

I have a JOB configured in SQL to run every 30 minutes, it has 2 steps, 1 procedure in each step, but when the first step reaches 1 minute of execution, it quits without executing all the registers it should and starts the second step. How do...
asked by 30.10.2017 / 12:15
2
answers

SQLSERVER compare two groups of results

I need to query the sql server where I have to "connect" inventory to the companies. The stock has 'n' products attached to it, and these products have 1 category attached to it. The company also has 'n' categories attached to it. I nee...
asked by 03.11.2017 / 20:21
1
answer

Select Electronic Point Record (SQL)

How can I collect only the first and last mark, where an official can have X Markings and even markings the next day? As the example below +------+--------+-------+-------+ | FUNC | DATA |ENTRADA| SAIDA | +------+--------+-------+-------+...
asked by 01.09.2018 / 21:35
1
answer

Transform rows into a select column - PIVOT - SQL Server

I have a SQL query that returns the following result: Inquiry +--------------------------------------------------------------------------+ | CONJUNTO | TIPO | FILHO | PAI | TIPO_CONTEUDO | TIPO_DESCRICAO | +---...
asked by 21.09.2017 / 22:32