Questions tagged as 'sql-server'

Tagged questions
1
answer

SQL allocate record (RowLock)

I'm developing an application, and I'm facing a problem about registry competition. What happens is that I have several people who can access the same record, so I needed that when a user clicked edit, I would allocate that record. Finding...
asked by 26.09.2016 / 18:18
0
answers

Error in functions sqlsrv_query and sqlsrv_num_rows ()

Good afternoon, I do not have much experience in php I'm starting now with this language and I'm having a problem with two functions follow problem print:    Warning: sqlsrv_query () expects parameter 1 to be resource, boolean given in ... da...
asked by 03.09.2016 / 20:36
1
answer

Search Previous Record (Mileage)

I'm trying to set up a supply management report. I have a Supply Table with the following fields: DataAbastecimento, CódigoVeiculo, KmAbastecimento, Quantidade, Valor In the Report I am doing, I need to know the KM Traveled ... then follow...
asked by 15.09.2016 / 18:40
1
answer

How to check for integrity or violations in SQL Server database?

I created an application to run in the background to back up my SQL Server database using the Backup class of Microsoft.SqlServer.Management.Smo . I would like to add to this backup tool something that can check the integrity of the d...
asked by 28.07.2016 / 20:20
0
answers

Error Entity Framework class mapping from existing database

I have a SQL Server database and have the mapping classes automatically generated from the existing database. However, when I run the application, it gives the following error:    (404,10): error 3015: Problem in mapping fragments starting at...
asked by 14.07.2016 / 02:21
1
answer

Concatenate SQL Server records

I have a problem in a query, where I need to concatenate records from a table. I need select to take the FormID and concatenate the records of AcaoID only if Permitir is 1. p> Query: Declare @Result varchar(...
asked by 28.06.2016 / 16:01
0
answers

SQL Server - Create a View on a server with tables from another server

Hello. We had a SQL Server with three banks, one of the application I developed, two of two different systems, the Enterprise ERP system and the OnLine Order system. This OnLine Order system runs 24hs, so you are always updating the bank,...
asked by 29.06.2016 / 21:07
2
answers

Order by or filter in join Sql Server

You can use order by or some filter in inner join or left join or I'm trying to do this in the wrong way. I need to bring in a query a column that is in a daughter table, but I need to be the most recent record column of the daughter table recor...
asked by 30.07.2016 / 16:49
0
answers

Can not find Control ID in ControlParameter - Asp.Net

Hello, I have a question about getting the id of a book author and adding it to the creation of a book, and the book to be published should have an Auto Increasing Book ID, a book name, and the author ID. My question is to get the author ID o...
asked by 17.06.2016 / 20:50
0
answers

datasource connection, error when uploading JBoss

I'm trying to make a data source connection in JBoss, but without success. I've seen this tutorial to create my connection. Then the error occurred:   I have tried other tutorials, but in all of them I get the same error: Configuratio...
asked by 31.05.2016 / 21:19