Questions tagged as 'sql-server'

Tagged questions
2
answers

Hide a field in an SQL query

I have a SQL Server 2016 database and I need to hide the password field of a table, the idea is that with a SELECT can only be accessed by a specific user, I have no idea how to do it and I have only found with encryption using INSERT...
asked by 07.12.2016 / 16:25
2
answers

configure sql express

When installing sql express on a server and on the same network I have a client machine with which I want to enter the bd engine but I can not, previously I had been told that the sql express has to make a configuration but the truth is not what...
asked by 28.10.2016 / 21:33
1
answer

Visual Studio - Entity Framework

Does anyone know why I can not change the inherited provider option? I need to put it in true, like the project on the right and it appears blocked. Thank you in advance.     
asked by 28.11.2018 / 20:29
1
answer

Hide database records instead of deleting them [closed]

Recently I had the need to do a car crud, using Rest, Java EE, Angular v.6 and the database in SQL server, but with the difference that instead of deleting the records, they only they are hidden from the user and kept in the database. I want to...
asked by 14.11.2018 / 20:16
1
answer

Help in procedure or function error ... expects parameter @ ... which was not supplied

MY PROCEDURE IS: ALTER proc [dbo].[spinsertar_detalle_ingreso] @id_detalle_ingreso int output, @id_ingreso int, @id_producto int, @precio_compra money, @precio_venta money, @precio_especial money, @precio_especial2 money, @stock_inicial...
asked by 24.12.2018 / 05:03
1
answer

Convert columns of a table into rows

On a system I am currently working on, there is a table this way Id_Sucursal Id_Servicio F_Descarga Id_Tecnico Con_Costo_1 Id_Producto_1 Cantidad_1 Costo_1 Precio_1 Tipo_1 Oferta_1 Precio_Oferta_1 Cantidad_Oferta_1 Con_Costo_...
asked by 28.12.2018 / 17:42
1
answer

Join two tables into one in SQL Server

I have the following questions: SELECT * FROM #TABLE_AR_5 SELECT * FROM #TABLE_AR_6 This is my result: I need the information to be in a single table, I look for this result:     
asked by 13.11.2018 / 21:15
1
answer

Doubt about stored procedure that updates data [closed]

I am creating a stored procedure that updates me the data, at the moment of compiling it I am given this error "Incorrect syntax near the keyword 'SET'". CREATE PROCEDURE SP_Arriendo_Marcas_U @Nombre_Marca VARCHAR(25), @cMarca SMALLINT AS DE...
asked by 31.10.2018 / 21:00
1
answer

update with double condition in c #

I need to update a field of a record in my sql database using two conditions I'm trying to do it in the following way sql = "UPDATE detalle_pedido SET cant_ingresar = '" + Convert.ToDecimal(TextBoxCantidadCargar.Text.Trim()) + "' where codi...
asked by 30.10.2018 / 20:42
2
answers

How would you do toMost quantity of products sold in the summer months (January-March) of all years (from 2000 to 2006)

Show quantity of products sold in the summer months (January-March) of all years (from 2000 to 2006).     
asked by 16.11.2018 / 03:33