Questions tagged as 'sql-server-2012'

Tagged questions
0
answers

How to make entity mapping from the JPA database recognize the data type of the Database with

I am using Netbeans 8.2 project web classes Entity from a Database, mapping with JPA a database SQL server2012 from Microsoft. in the beginning I map with data types like Date, Image ... and others. Luxury, like this:  But after doing some...
asked by 02.10.2018 / 23:06
0
answers

SQL pivot, concatenate during the pivot

I'm trying to concatenate the data after the pivot select [ARC_ID] from (select [MTD_ID],[ARC_ID],[MET_ARC_VALOR] from [dbo].[TB_BGP_METADATA_ARCHIVO]) as SourceTable pivot(MAX([MET_ARC_VALOR]) for [MTD_ID] in([1],[2],[3],[4],[5],[6])) as P...
asked by 09.07.2018 / 23:24
0
answers

The input string does not have the correct format. C # SQLServer

Good morning, first of all a greeting, the error that I have is the following:    The input string does not have the correct format. I'll leave the code below, once I select the edit button to send the data of GridView just e...
asked by 27.06.2018 / 20:20
0
answers

Fill list with a query of the database

I have the following code: <td>MES:<br> <select id="mes" name = "mes" > <option value = "1" <%if PMES="1" then %> selected <% end if%> >ENERO</option>...
asked by 22.06.2018 / 23:20
0
answers

Export file with several tables

Hello Good afternoon, I hope someone can give me an idea with this matter I have my database with several tables (users, invoices, types, brands, equipment, components ...). One of the requirements of the system is that the user can generate...
asked by 11.06.2018 / 18:43
1
answer

The function or procedure has too many arguments

Help me with this error occurs if I execute a stored procedure more than once in the following process: the error occurs inside the foreach when it enters a second time public string habilitarcredencial(int idusuariom, GridView sistemas, int r...
asked by 30.04.2018 / 05:59
1
answer

reference field generated in stored procedure sql server

I'm doing a stored procedure, to add some data to a report in crystal reports. I'm doing the following: (df.valor_unitario * df.cantidad) as vtotality, /*realiza la operacion y el resultado lo muestra en el campo vtotality */ (select sum(vtota...
asked by 24.04.2018 / 18:13
0
answers

Why do I get this error when an inner join query?

because if I do it with a normal query it does not give me this error, but if I do it with a query with inner join it throws me the error of the image This is what I want the query to do, obviously with the inner join it would show the...
asked by 21.04.2018 / 19:02
1
answer

Help How to concatenate an nvarchar field and a datetime type in SQL SERVER 2012

Good morning I wanted to know if you can help with the next query I want to concatenate an NVARCHAR field with a DATETIME this is my code SELECT CONVERT (NVARCHAR(10), u.COMPROBANT)+' '+'del '+ CONVERT(VARCHAR(10),u.FECHA_TRS, 103) AS 'Comprob...
asked by 17.04.2018 / 18:18
0
answers

sql server 2012 BackUp error

Good day, I want to backup my database but when I do it I get the following error :    The backup of the file or group of files "sysft_CatalogoMedicos" is not allowed because it is not online. Container status: "Offline" (7).       Restorat...
asked by 26.03.2018 / 22:01