Questions tagged as 'sql-server'

Tagged questions
0
answers

How to import data from an excel file to asp.net core 2.1 mvc and then store it in a sql server database with C # language?

I am new working with asp.net core and the tutorials I find now to import or export are for version 2.0 which includes web forms, but from version 2.1 the web forms were no longer incorporated. Thank you in advance.     
asked by 22.11.2018 / 17:38
0
answers

see a table with the buttonfield of my gridview

My problem is the following: in my gridview I put a buttonfield to expand the information I have in that row, but I do not work the code I did so I thought so Any ideas? preened in advance protected void grDatos_RowCommand (object sender,...
asked by 22.11.2018 / 21:17
0
answers

Connect SQL Server with Macro in Excel

on this occasion I want to request your valuable help. I have a stored procedure with 3 parameters in SQL and I need to create a Macro in Excel with 3 text fields that will feed the parameters. Then, I must collect the result of the Execution of...
asked by 22.11.2018 / 23:38
1
answer

How to add values to a detail without duplicating them

Good morning everyone I hope you can help me with this doubt I have a table in java where I load records from my table detail in sql server, as shown in the image. The fields that the table has in the database are the same as those in t...
asked by 21.11.2018 / 21:16
0
answers

Separate SQL Server counters

My question is as follows I have a calculated column that concatenates a value with the column number to generate the field: CREATE TABLE #Ejemplo ( ID INT IDENTITY, NumeroRadicado AS ('AG' + RIGHT(REPLICATE('0', 15) + CONVERT(VARCHAR...
asked by 21.11.2018 / 22:14
0
answers

set value of an object traversed by ng for, to a ng form in a hidden input in angular 7

I have a problem to pass the value of an object to an input of type hidden in an angular form, to be more exact, I have a modal in which I have a form to update a table, the problem is with NgModels and NgForms managed to send the body to my API...
asked by 21.11.2018 / 21:08
0
answers

Insert / Update of record in a TableAdapter with Joins

Good Day. This is working with DevExpress and I am implementing the data update through DataBindings and TableAdapters. The problem is that the queries I require consist a lot of the Joins and it is not a viable option to use SubQuery's in...
asked by 13.12.2018 / 00:38
0
answers

Generate an ER model in sql server management studio 18

Hi I am trying to generate an ER model in sql server management 18 but I can not find the option if I enter the database the model folder does not appear     
asked by 21.11.2018 / 12:28
1
answer

How can I generate the next one caught in SQLSERVER when I insert a data?

I want to record data of requests in a table, however they asked me to generate a unique code for the request and that it will take the structure that I show in the following image: I have absolutely no idea how to do it, if someone can...
asked by 23.11.2018 / 05:32
0
answers

How to configure mirror servers in ubuntu server 16.04?

I have 3 servers with the Ubuntu Server 16.04 system to which SQL Server 2017 Developer installs them. I'm trying to make a mirror configuration between these 3 servers (main, mirror and witness) but at the moment of finishing the configuration...
asked by 17.11.2018 / 01:15