Questions tagged as 'sql-server'

Tagged questions
1
answer

Help with connection to database sql server 2008 and android

I followed a tutorial on the connection of Android Studio with SQL Server 2008 r2 (already existing), with which I could make the connection normally, but I have a problem. I can make the connection to the bank if the connection to the bank is s...
asked by 22.06.2016 / 14:23
1
answer

ADODataSet Delphi Edit

I have ADODataSet with the following query DECLARE @ID_CONTRATO_EMPRESARIAL INTEGER = :ID_CONTRATO_EMPRESARIAL BEGIN WITH V1 AS ( select C.ID_CONTRATO, COUNT(CASE AD.FUNCIONARIO WHEN 'TRUE' THEN 1 ELSE NULL END) FUNCIONARIOS, C...
asked by 24.05.2016 / 15:06
2
answers

Compare values from the same field in a table

I'm starting in SQL and there was a problem that I can not resolve. I have a table on which are registered payments from multiple customers, each customer made 6 payments. I need to know how many customers made the 6 payments ever with the sa...
asked by 07.05.2016 / 19:14
1
answer

Windows user in IIS

I'm trying to log on to a SQL Server 2008 database, with the windows user accessing my published site in IIS. I've configured Web.Config for windows authentication, set up the application pool, leaving identificador equal Aplication...
asked by 04.05.2016 / 14:43
1
answer

Column to write date and time of change SQL Server

I am migrating a database from Firebird to Sql Server and today, in Firebird I have some triggers in Before Insert/Update that write TimeStamp of insertion / change and user logged in. Is there any way I can...
asked by 11.03.2016 / 18:13
3
answers

How to group results in a row?

I would like to perform a query on the FILE_EXAME table with the following data: CREATETABLEFICHA_EXAME(FICHAsmallint,EXAMEVARCHAR(15));INSERTINTOFICHA_EXAMEVALUES(1,'Hemograma');INSERTINTOFICHA_EXAMEVALUES(1,'Colesterol');INSERTINTOFICHA_EX...
asked by 10.12.2015 / 14:28
1
answer

Error connecting SQL server

Hello, I downloaded SQL Server Express 2014 with tools from the Microsoft website. I did the installation however when I start the error Error description: TITLE: Connect to Server ------------------------------ Cannot connect to wil...
asked by 13.12.2015 / 23:42
1
answer

How to write the value with decimals before the point in the sql server?

I have a field in the bank with this format TESTE numeric(8, 3) I want to record this form. UPDATE TB_PLANO_CONTAS SET TESTE = 001.000 WHERE IDPLANOCONTAS = 63 The result looks like this: 1,000 UPDATE TB_PLANO_CONTAS SET TE...
asked by 13.11.2015 / 18:18
1
answer

SQLServer does not check information correctly in Delphi application

I have a login screen in Delphi + SQLServer where the goal is to compare the data sent with the ones in the database! 1st Scenario: If I add the incorrect password and correct login. error! 2nd Scenario: If I add random text in...
asked by 19.11.2015 / 17:21
1
answer

Error: procedure or function has too many arguments specified

Criei uma procedure para popular uma grid view: create procedure [dbo].[spc_listaafiliadosadmin] ( @nome varchar(100), @login varchar(100), @cpf varchar(100) ) as begin if(@nome is not null) begin sele...
asked by 18.09.2015 / 21:05