Questions tagged as 'sql-server'

Tagged questions
1
answer

Insert in SQL fields not null

Hi, I have the following question. It's something very basic but now it has me stranded. I want to make a query to a table from sql server managment. The problem is that I have the Id that turns out to be primary key, not null and it is self-inc...
asked by 18.10.2017 / 21:30
1
answer

Insert SQL query with AJAX and ASP.Net

Hello, I need to do a SQL INSERT using ajax in ASP.NET, I'm not sure what I'm missing. $('#submit').click(function () { insertFeedback(); }); function insertFeedback() { var modelx = new Object(); var depS = documen...
asked by 18.10.2017 / 23:38
2
answers

SQL Server, query data from a table using joins

Good, I need help because I can not find a problem, I have a table 'A' of meetings and a table 'B' of users, table A contains a field called 'Organizer', which stores the Login of a user (eg: Juan Perez, your login it's 'jperez'). Table B stor...
asked by 16.10.2017 / 22:04
1
answer

Avoid getting out 0.00 in SQL server query

I have this query and send a 0.00 data and I do not want to be killed my query: select Descuento = isnull(( SELECT sum(x.Valor) FROM Cuenta x where x.IdSer between 25 and 39...
asked by 01.11.2017 / 16:27
2
answers

How to insert data from timepicker, textbox and all the contents of a datagridview? visual studio 2015

I have a big question about ... How do I make multiple entries into my database the records that are inside my datagridview and also outside it? for example: A trip of such date that would be a data of the datetimepicker, the name that has th...
asked by 04.10.2017 / 17:27
2
answers

Invalid Column Name in a table created with Querys in a Stored Procedure

I want to create an SP with two parameters, Date and Bank, the purpose is that each bank must show (among other data) all the clients in that bank and the amount of cash that will be available in 24.48 and 72 hours. after the Date parameter. The...
asked by 09.10.2017 / 22:22
2
answers

Two Models in an MVC view 5

I have two Models: public class Solicitudes { public int SolicitudesID { get; set; } public DateTime FechaEmision { get; set; } public DateTime FechaInicio { get; set; } public DateTime FechaFin { get; set; } public string...
asked by 09.10.2017 / 23:30
1
answer

Queries with DATETIME

I want to return the following values as shown below: fechaActual Clave Usuario Depto entrada salida sumaHoras 201712 307 USER1 TTT 06:00:04 14:04:12 8 The query must take the current d...
asked by 04.01.2018 / 06:16
1
answer

how to transpose columns and show percentage? SQL server

This is my code: select ROW_NUMBER() OVER (ORDER BY p.CodPersona) AS Numero, ccc.Descripcion AS Curso, p.CodPersona AS Codigo, p.NombreCompleto AS NombreAlumno, cc.Detalle AS Detalle,...
asked by 25.09.2017 / 18:57
2
answers

executenonquery in C #

Greetings, I would like to know what value returns me executenonquery in case I do not affect any field, example string respuesta = ""; SqlConnection SqlConexion = new SqlConnection(); try { SqlConex...
asked by 31.10.2017 / 13:54