Questions tagged as 'sql-server'

Tagged questions
2
answers

Voucher count showing all months

I have a voucher count that is already done and I get bounced by date, now the problem that I want to show all the months of the year, could help me in this function that my head is flying. that friends advise me example: name | mov | January...
asked by 07.12.2018 / 14:49
1
answer

Compare names between a SQL-SERVER field and a windows folder - C # - Windows Forms

I have created an application that allows me to validate the existence of images with any type of extension using the numero_guia(GUIA001__789656.tif) as a pattern. Currently my app works without problems, but I would like to improve...
asked by 03.12.2018 / 16:43
0
answers

Port error tcp ip in java connection with sql server

Well, more than problem in the code I think it will be installation but, well, if you can help me, I would greatly appreciate it: It all starts when I have to install sql server 2014 express edition on a client's computer, all right, you can eve...
asked by 04.12.2018 / 20:17
1
answer

How can I make this structure in Json from SQL 2017?

I want to convert this structure by selecting data from the table when I select it, I am going to convert it into JSON from database Sql 2017. ATTACHMENT MY QUERY Select Medio_Pago AS [medio_pago] from Table_FacturacionElect where Comprobante...
asked by 29.11.2018 / 01:34
0
answers

Validate client ID to export in SQL Server

Friends, good evening, I hope I can explain myself well about the problem I'm having. I am currently doing an export in SQL With the following query: SELECT IDFactura, FechaDocumento, NombreCliente, NIT, DireccionFacturacion, FOLIO, Sub...
asked by 29.11.2018 / 03:59
0
answers

when IDENTITY_INSERT is set to OFF - SQL SERVER

Now that I execute the trigger, it does not allow me to insert. I get the following:    Msg 544, Level 16, State 1, Procedure TR_TB_DISTRITO_INS, Line 5 [Batch Start Line 28] Can not insert explicit value for identity column in table 'TB_DIST...
asked by 05.12.2018 / 16:07
0
answers

How to generate a report in an mvc project 5

Hi, I am new by programming on asp.net mvc, but I wanted to know or to suggest how to generate a report to print, the idea is that I have developed an application with a database on sql server, based on the information create the report and the...
asked by 06.12.2018 / 04:11
2
answers

Error assigning the default value to input parameters

I am trying to assign a default value to the parameter of date type but it is not leaving me: CREATE PROCEDURE DATOS( @FECHA_INICIO DATE = "1-01-2000", @FECHA_FIN DATE = "12-31-2010") AS BEGIN SELECT * F...
asked by 04.12.2018 / 10:11
0
answers

Pass data from one view to another view MVC 5 Entity framework 6 sql server

I have a view where I load the information of what I call an initiative which is linked to a Tleads table, this is the view. <br /><br /><br /> <div class="panel panel-primary"> <div class="panel-heading">...
asked by 26.11.2018 / 18:21
0
answers

An sql event can be conditioned

I have this event CREATE DEFINER='root'@'localhot' EVENT 'prueba' ON SCHEDULE EVERY 1 YEAR STARTS '2018-11-23 16:35:00.000000' ON COMPLETION PRESERVE ENABLE DO UPDATE cat_marca as tabla_c SET tabla_c.precio = (SELECT tabla_c.precio * tabla...
asked by 23.11.2018 / 22:34