Questions tagged as 'sql-server'

Tagged questions
1
answer

Help with a SQL query, sums

I'm doing an SQL in which I want to add whose product is similar that is. I have my sql, I attach them to you. select distinct cat.Nombre as Categoria, pro2.Nombre as Producto, InventarioInicial, ocd.CostoUnitario from Inventario as inv2 in...
asked by 12.07.2018 / 19:04
0
answers

Configure Sqlserver with php

Good afternoon I'm working with php and I need to connect it to a sqlserver database engine and download the windows drivers I added them as extensions and configure the php.ini but it still does not work. I appreciate who can guide me in the co...
asked by 04.07.2018 / 19:08
0
answers

Get fields changed in a trigger

I am doing an audit system and what I have done is a trigger in which the inserted is obtained and saved as JSON in a column, as well as the deleted, but I also want to save the changed fields between inserted and deleted, in postgres I did it u...
asked by 06.07.2018 / 12:01
1
answer

Purchase XML in SQL SERVER

I have two xml and I want to see which fields were modified, however the result is not formatting them as they were entered: DECLARE @xml1 xml ='<id>41</id><codigo>00054</codigo>'; DECLARE @xml2 xml ='<id>41</i...
asked by 06.07.2018 / 05:51
0
answers

SQL server stops inserting records with my insert instruction

I have a table with records id(int) nombre(varchar(50)) 1 juan 2 pedro 4 aldo When executing my sentence $size = count($_POST['id']); $i = 0; while ($i < $size) { $id1= $_POST['id'][$i]; $nombre1 = $_POST['nom...
asked by 12.07.2018 / 18:12
0
answers

Export to excel without reportviewer Visual C #

I'm doing some forms with ReportViewer from visual studio 2017, but when doing them there is one that takes about 5 minutes are around 3000 records, my question is if there is any way to export this information without viewing the reportviewer s...
asked by 04.07.2018 / 23:37
0
answers

The database is not created using entity framework

Basically I followed all the steps as I understand how you can see this is the DBContext that I have created. namespace MODELO { using System; using System.Data.Entity; using System.Linq; public class Ouroboros : DbContext...
asked by 04.07.2018 / 10:32
1
answer

Fill TextBox with TextMode = Date of Asp.Net from Date SQL

I would like to know how I can fill a "Date" type textbox with a date obtained from a SQL Server table Currently I have it like this txtFecha.Text = (((DateTime)firstTable.Rows[0]["FechaCredito"]).ToString("dd/MM/yyyy")).ToString(); Bu...
asked by 02.07.2018 / 21:50
0
answers

Dynamic Nav asp.net core sql server

Hello, I would like you to help me. I am new to asp.net core and I am making a login that if it is correct enter and through the database of the procedure I return the menu according to the user who enters. That is, in the database I have made i...
asked by 27.06.2018 / 15:22
0
answers

read Json type data from SQL and send it to a text file

Hello friends, start working on a C # code that you have to do only, read a query in my database (that query converts my table to Json type formats) then the result of the query has to be sent to a Json type file. I have never worked with Json t...
asked by 27.06.2018 / 09:07