Questions tagged as 'sql-server'

Tagged questions
1
answer

How the SQL Agent is active in SQL Server Management Studio

I want to use a job in my data base, for that I need to activate the Sql Agent Try to activate it from my control panel but it still does not appear to register my job     
asked by 02.07.2018 / 20:48
2
answers

Procedure or function 'InsertaUsuario' expects parameter '@name', which was not supplied

I have an error when calling my procedures on vs, I am trying to insert users. My procedures are the following: Here I have the name, type of users and ID ALTER PROCEDURE [dbo].[InsertaUsuario]( @id int = 0, @nombre nvarchar(50), @memo nvarcha...
asked by 08.06.2018 / 16:17
1
answer

Query Sql with problems

I have the following query select A.AuxstockArrProductoId, B.ProductoNombre, (A.AuxstockArrSubctaCant)as total from AuxSctaStockArr A inner join Producto B on A.AuxstockArrProductoId = B.ProductoId group by A.AuxstockArrProductoId having...
asked by 29.05.2018 / 00:22
1
answer

CREATE TABLE error after IIS APPPOOL ASP.NET-SQL

I have a web application to mount in the IIS, the question is that when I try to visualize some view that uses data from the BD I showed the error of IIS APPPOOL\Licorera . Checking the internet to fix that error was to give the user pe...
asked by 25.05.2018 / 19:52
1
answer

TDBXTypes.DOUBLE error with Delphi

I have this error I can not solve it, search in many forums but I can find a solution. I am developing in delphi a client-server program with datasnap. This error appears when I execute an INSERT procedure on sqlserver: Client side scri...
asked by 17.05.2018 / 04:35
2
answers

Help with SQL query

I have this query that brings me the people who marked that they want to do a course called "courtship" but what I would like to add are also those that marked other courses, for example "Finance", "Youth". this is related to answers.preguntaid...
asked by 09.05.2018 / 17:21
1
answer

how can I concatenate records from the same column in sql server?

If you could help me, I have a table like this: identificativo fecha 72028586 11/05/2018 72028586 13/05/2018 72045976 17/05/2018 72063798 13/05/2018 and I need to make a query to show me th...
asked by 21.05.2018 / 18:07
1
answer

Error in laravel application with sql server in windows

I have configured the xampp v3.2.2 with sql srv, I have a laravel 5.5 application configured to connect to the sql server as follows: APP_NAME=Laravel APP_ENV=local APP_KEY=base64:SFla+HfV2OBTy/KYCrSZeBbwGWMUfZBKrnKwNzJrfQU= APP_DEBUG=true AP...
asked by 21.05.2018 / 16:01
2
answers

Modify a date in SQL Server

My problem is that I want to add a certain number of hours and minutes to a date and save it. The problem is that it marks me an error in the type of data conversion. How can I modify this date so I can save it with the hours and minutes already...
asked by 30.04.2018 / 11:42
2
answers

Insert Error in a Linked Server

I have the following problem, I am running a script that makes an export of a SQL Server 2012 server to another SQL Server that is tied by a Linked Server, the script is as follows: INSERT INTO [192.168.10.82].[INTERFAZ_IQWARE].[dbo].[T_FACTUR...
asked by 03.05.2018 / 20:12