Questions tagged as 'sql-server'

Tagged questions
2
answers

Error in SELECT with several tables WITH SQL SERVER

Good I am doing a query query only with a select with several tables this is my query in the image that I will attach the following error: DECLARE @Buscar AS VARCHAR(16) DECLARE @NCuota AS INTEGER SET @Buscar=('1010100368233') SET @NCuo...
asked by 16.02.2017 / 17:57
1
answer

Error Recover when saving or retrieving a BD SQLServer image

When saving the Image in the database it is saved in a field of type Image the problem is that when recovering the image and receiving it in a variable type [] byte doing the correct conversion I can not visualize in the control destined, I...
asked by 17.01.2017 / 15:08
2
answers

Query dynamic?

I have the following query: select CONCAT('PtdBal',(select right(substring(PerNbr,5,2)-1+100,2) from SLApplication.dbo.GLSetup)) from SLApplication.dbo.AcctHist where substring(Sub, 16, 6) = '189621' and acct like '822%...
asked by 01.02.2017 / 01:46
3
answers

How to run php script and update view?

I need you to give me an idea of how to solve the following problem ... It is required that when a search is made, the searched product is registered in a database and the time, and it is necessary to show the data of the search in a new form, w...
asked by 10.12.2016 / 01:14
1
answer

how to make SQL Server change the status of a record automatically when a certain time arrives?

I'm doing a queue system and I need that after 30 minutes that the user entered the queue, the system changes its status from true to false but without any request to the server, it does so directly in the database, Can you?     
asked by 26.02.2017 / 01:16
1
answer

Database with sql server and c # win forms

Hello friends, I have a database like the one in the figure and I manage it from an application in c # windows forms The problem I have is with the intermediate tables (testsQuests and questionsOptions). When creating an entry from anot...
asked by 25.01.2017 / 16:12
1
answer

Error using openrowset

I have a problem regarding openrowset . I am running the following encoding: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\Procesos\PRUEBA.xlsx', [Hoja1$]) and I get the following error:    The O...
asked by 05.11.2016 / 00:44
1
answer

Run trigger (Sql) for multiple fields

I am working on a sales system for food sites with c # and SQL. I have created a trigger that decreases the stock when a product is added to the sale. Each product (plate) is related to a table that stores the ingredients and how many of them ar...
asked by 20.12.2016 / 06:13
2
answers

Too much response time in a Sql Server procedure

I have the following code in a procedure: DECLARE @Temp_Entidades TABLE(Id int); with Report(Id) as ( --primer select select distinct e.Id from EntidadesPersonas as ep right join Entidades as e on ep.EntidadId=e.Id where...
asked by 21.10.2016 / 21:06
1
answer

Errors when installing SQL Server 2012 (sqlwriter.msi) which then tells me that the user does not exist

During the installation, there is no error in the wizard's requirement checks and everything is in order. I followed the instructions of the most popular video of installation of the program on YouTube. At the time of installation is where er...
asked by 04.12.2016 / 23:20