Questions tagged as 'sql-server'

Tagged questions
1
answer

Integration Services Components - SSIS - Data Flow [closed]

Hello! I have a need to develop a component for Integration Services (SSIS) - > Data Flow. I already have components developed for the Control Flow area, but I have never developed anything for Data Flow. I tried to find something about th...
asked by 15.05.2017 / 21:22
4
answers

Select only the first line of the table [duplicate]

I need to select only row 1 from the table, I already used DISTINCT and it did not work Follow Query: select Max(remessa.dt_uso_inicio) as DATA_REMESSA ,min(dt_entorc_oficina)DATA_ABERTURA ,patr.nr_patrimonio AS PATRIMONIO from...
asked by 23.03.2017 / 17:19
1
answer

Insert data into a table with foreign key in ID

I'll try to be as objective as possible so not many codes will I put (because the original is really too big). I'm doing a simple registration program that has:  - 1 datagridview to select the desired customer from a list of records  - 1...
asked by 17.03.2017 / 14:36
1
answer

String or binary data would be truncated

This error occurs when I try to execute my procedure, I do not know why this happens. My code: Dim con As SqlConnection = New SqlConnection() Dim cmd As SqlCommand = New SqlCommand() Try con.ConnectionString...
asked by 03.03.2017 / 17:05
1
answer

Import decimal with comma

In SQL Server, I am trying to execute a SELECT in a * .csv file as follows: SELECT * FROM OPENROWSET(BULK 'C:\Minha_Pasta\meu_arquivo.csv', FORMATFILE = 'C:\Minha_Pasta\format.xml') AS Contents meu_arquivo.csv...
asked by 23.02.2017 / 22:26
2
answers

How to configure XAMPP for Sql Server 2014 [duplicate]

Can someone teach me how to configure XAMPP for Sql Server 2014? I'm in a project that does not allow Mysql (PHPMYADMIN).     
asked by 23.10.2017 / 11:19
2
answers

MS SQL Server StoreProcedure returning resultset

I am new to the SQL server and I need to create an SP that processes certain tables and writes changes and then returns the results of these changes to me as a table-value function for PHP. I tried this: create procedure auto_fill_test...
asked by 12.01.2017 / 15:06
2
answers

Error doing query with between in datetime field

I'm trying to do a between but I do not know how to proceed. where cliente.id = (select usuario.idCliente from usuario where usuario.login = 'julio') and (cast(os.dataHora as date) between '2016-09-08' and '2013-10-29') or where client....
asked by 07.11.2016 / 03:30
2
answers

Single line and column result for multi-line column [closed]

I have a function in SQL that returns a single row in a single column with records separated by periods. Example: Column 1: Result Line 1: 0000000.0000001.0000002.0000003.0000004.0000005.0000006 I would like to insert each value o...
asked by 06.01.2017 / 19:47
2
answers

Conversion of type VARCHAR to SMALLDATETIME

SELECT DISTINCT p.codInterno, CASE WHEN f.idFabricante IS NULL THEN 99999999999999 ELSE f.idFabricante END AS fabri, '0', p.descResumida,...
asked by 27.12.2016 / 16:39