Questions tagged as 'sql-server'

Tagged questions
1
answer

Know what permissions a user has in SQL Server?

I have a user that only allows me to make queries in SQL but I need to know by means of a query what permissions this user has in SQL Server.     
asked by 11.05.2018 / 16:53
0
answers

Mail by mailgun sql server

Good, I wish you could help me. I am creating my domain by mailgun but I want to configure the domain but when configuring and sending a test email, do not send I would like you to help me     
asked by 25.04.2018 / 00:46
1
answer

Error using STUFF in SQL Server

I have a query and I want to group data from one column in a row, separated by a comma, through examples I could put together the following query, but when I run it I get The multi-part identifier "arr_inventario_sal.ains_folio" could not be bo...
asked by 25.04.2018 / 01:23
2
answers

Group and Sort in Sql

Hello, good morning, I request a help or guide to try to solve a query in sql, it should be noted that I am new in this world; I am trying to make a query that shows the last record by item code that is to say I have values such as item code, da...
asked by 25.04.2018 / 03:48
1
answer

My view of javafx does not raise from the netbeans side

I am creating a project from Netbeans, javaFx and SQLServer. My problem is that I created a view from the side of javaFx and then I did the configurations (Add Controller, Identify the objects and assign the events), but when I run the Netbeans...
asked by 25.04.2018 / 04:07
0
answers

Connect jdbc sqlserver in soapui MockService

When making a connection to the sql server in a MockService using soapui version 5.4 I get the following error:    INFO: groovy.lang.MissingPropertyException: No such property:   connectionUrl for class: Script1 The code I have is the fol...
asked by 28.04.2018 / 00:17
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

Summon procedure stored in sql from Java

I would like to know what I am doing wrong, by returning a ResultSet that executes a stored procedure that performs a select on a sql table. I'm working on Java I have a java project that serves as the data layer where I connect to the databa...
asked by 17.04.2018 / 19:30
1
answer

Error opening a database in SQL Server 2008

I do not know what the following error should be: USE BD_INVENTARIO GO Mens. 945, Nivel 14, Estado 2, Línea 1 No se puede abrir la base de datos 'BD_INVENTARIO', porque no es posible tener acceso a archivos, o la memoria o el espacio en disco...
asked by 17.04.2018 / 19:10
1
answer

ASP.NET MVC: Save an int variable from a select query on sql server

My problem is as follows. I have a code for a login, where I keep the username of the user who logged in Session["USERNAME"] . What I'm trying to do is put in my variable wea the ID of the user who just logged in using his username...
asked by 18.04.2018 / 04:18