Questions tagged as 'sql-server'

Tagged questions
2
answers

What is the best way to query SQL Server database using a list entry?

I have a question as to how best to approach the following problem: I need to query records in a SQL Server table using a list of serial numbers. I know the IN command, but it does not answer because it is limited to receiving a maximum of 2100...
asked by 13.01.2015 / 13:35
1
answer

Login failed for user "NT \ IUSR AUTHORITY"

With a WebService application running in IIS, but how much do I try to consume from this error:    System.Exception: Login failed for user 'NT \ IUSR AUTHORITY' I have tried to add this user, but I can not seem to get this error:    Th...
asked by 11.08.2014 / 21:00
1
answer

Insert data into Active Directory via SQL SERVER

I'm working with integration between Sql Server and Active Directory. I can already import AD information through scripts. I would like to know if it is possible otherwise, through insert commands, to insert information into AD users. For exampl...
asked by 08.08.2014 / 16:53
1
answer

SQL query grouping by age group

Hello, I need a way to do an sql query that will bring me the amount of male and female people. NOTE: I have two tables where the first one is registered in it I have the sex column and another table that would be entered only with the addressna...
asked by 02.09.2015 / 15:56
1
answer

Order by SQL Server in Procedure

Hello, I am in the following situation: I need to select the amount of care of people of some age groups and of those who are male and female. I have the following tables: cadastro (id, natendimento, data, sexo, fokfaixaetaria) and fa...
asked by 02.09.2015 / 21:31
1
answer

DBLIB PDO AND UTF-8 CODING

I'm in a project using 64bit UBUNTU-SERVER as WEBSERVER. In the project I chose the database Microsoft Sql Server 2012 which I have a use license acquired shortly. With much effort I got the connection using some libs like sybase freetds ......
asked by 24.02.2016 / 18:21
4
answers

Filter using only month and year in SQLSERVER

I need to mount a select, in which the filter is used only the month and year in the parameters. This is the select I'm currently using, but I need the 'day' not to influence my search. SELECT NOME_CLIENTE, COUNT(NUMERO_BILHETE) AS...
asked by 03.01.2019 / 14:45
2
answers

Create Trigger to change record only when modifying a field

I have a SQL Server database table, I have a column that shows the status of that database ('A','I','S','C') . I created a field named Update_data , which will receive a datatime every time the client changes the registration stat...
asked by 22.12.2018 / 02:57
1
answer

Insertion error in the database, how to solve this case?

I'm trying to insert a form with various data, some booleans, radiobuttons, datetime etc. I need to know if everything is correct, I'm catching them via FormColleciont . Controller: [HttpPost] [ValidateAntiForgeryToken]...
asked by 17.05.2014 / 04:59
1
answer

MultiTenancy application and structure

SaaS applications are on the rise, reducing costs, maintenance, etc. We know we have the concept: MultiTenancy ( link ) They are: By Column: Put an idClient column on all tables By Schema: Separate clients by schema, client1.contacts...
asked by 17.07.2014 / 21:28