Questions tagged as 'sql-server'

Tagged questions
1
answer

Configure API for SQL Server database

I have an API that I used with MySQL, but I had to switch to SQL Server. Unfortunately I've never used SQL Server, I do not know if I need to download something to get it. The API was done in JS. The configuration of the sequelize of my API with...
asked by 08.03.2018 / 13:02
1
answer

PK error during process asynchronous process

Personally I came across a situation where I solved the problem but I would like to know more about how UPDLOCK works. I had a situation that was basically like this within a procedure: SET @MAX = SELECT MAX(NRDOC) FROM TABLE1 WITH(NOLOCK) SET...
asked by 30.03.2018 / 14:31
1
answer

Query query in SQL Server 2012

I need this query to come only with records where the CURVE ABC column is different from the MODEL column. For example, this customer's ABC curve is silver and the model is diamond / gold, so it turns out that the name silver is not in the mo...
asked by 09.02.2018 / 14:25
1
answer

Doubt - Case when inside a stuff - SQL Server 2012

Well, how do I put a case when exists inside the query below. The result is currently working out like this: Customers Drugstore, Soccer, Gelagua However, I want to put a case when exists if it is in the condition, come yes, yes, not come....
asked by 31.01.2018 / 20:56
0
answers

Limit SQL Server memory per user

I would like to know if you can limit memory usage and limit SQL Server query time by users: Block query execution time per user. Block the memory used in the per-user query. The reason: Some users perform queries that take a long ti...
asked by 05.03.2018 / 15:45
1
answer

Configuration datasource

I have a java application running in wildFly 8 and using Sql Server, the problem I'm having at the moment is that the application comes back to me saying that it was not possible to open the connection, I checked the code and all the features wh...
asked by 26.02.2018 / 14:53
1
answer

How to assign a database value to a new object in C #?

I'm creating an application like a bank to train C #, but I stumbled into a situation. I have a database with the Accounts, Clients, and Account Types tables. In the table TypeCounts there is registered the item "Savings" with ID "1" and the ite...
asked by 03.03.2018 / 00:34
1
answer

Use TIMESTAMPDIFF in table creation

I'm adding mysql support for my program, currently it only works with sql server, so I came across a problem with mysql. Table sql server: CREATE TABLE [dbo].[login_user]( [idx] [int] IDENTITY(1,1) NOT NULL, [client_id] [int] NOT NU...
asked by 28.12.2017 / 16:03
2
answers

Make item table update with stock on any branch

Alright, people, I have a table with stock of products in a network with 13 stores. I want to block items that have no inventory in any store and that have not had sales in the last year or that were only registered, but did not sell. I tried...
asked by 26.01.2018 / 18:48
1
answer

Document search screen with pagination and search filter with asp.net [closed]

I have the layout of a search screen, it has to show documents from my sqlserver database. To facilitate the search I put filter and as they are very documents it would be interesting to do pagination. I'm still learning; so if anyone has a good...
asked by 27.12.2017 / 01:40