Questions tagged as 'sql-server'

Tagged questions
1
answer

sql queries with sql server 2016

I'm writing to see what's wrong with this query: Name of the teacher who teaches all subjects first select nombre from profesor inner join imparte on (profesor.p# = imparte.p#) group by nombre having (curso like "primero")     
asked by 13.06.2016 / 19:40
0
answers

I can not see the tables in the master database in SQL Server 2008 [closed]

I can not see the tables in the master database in my SQL Server 2008 R2 , enter the database with the user sa strong> from SQL Server Management Studio 2008 and when expanding the tables I do not see any. Thank you in advance fo...
asked by 16.06.2016 / 00:25
1
answer

I can not make a transaction in the database

Good afternoon what happens is that my persistence.xml I have it configured with JTA and when trying to insert a data in the database it generates the following error. Caused by: java.lang.IllegalStateException: Exception Description: Can not...
asked by 14.06.2016 / 20:08
0
answers

migrate sqlserver database to postgresql [closed]

Will someone have a program to migrate from sqlserver to postgresql? I have recently used the ESF Database Migration Toolkit but unfortunately it is paid and the demo modifies the fields of the database with a "T" at the beginning of each record...
asked by 09.07.2016 / 18:33
2
answers

Unknown backup process - SQL SERVER

Hi friends, I have checked the log of the sql server and also the backup history and I notice that backups are being made to disk at a certain time but I see no maintenance plan or some JOB that does this, where else can the process be searched...
asked by 06.06.2016 / 19:50
2
answers

The name of column 'nroEmpleado' is ambiguous? SQLSERVER

I am doing the following query, however, it tells me that the name is ambiguous, I have read in several places and they mention that it is because I have 2 equal columns and the sql does not know which table I want to take the data from, but if...
asked by 20.10.2018 / 04:42
1
answer

Receive data from a stored procedure in c #

I would like to know how I can obtain a data from the stored procedure in sql server and then insert it into a variable type int in c #. Already I wrote a code that has to return me the ID greater than I have in my table, but th...
asked by 28.06.2018 / 11:26
3
answers

Error mapping entities from the database

I am developing an application in Windows 7 with NetBeans 8.1 and a SQL Server 2012 database. I have mapped the entities directly from the database but at the moment of starting my application I get this error:    Severe: Exception while prep...
asked by 11.04.2016 / 17:56
1
answer

SQL SERVER. Boolean field of an alphabetically ordered list

I have a table of people with various fields such as country, city, name, years ... What I already have is a query that, from each country and each city, brings out all the people who live there, arranged alphabetically. So now what I want is...
asked by 13.02.2018 / 18:23
1
answer

connect sql server with php on mac

I'm trying to connect sqlserver with php in mac but I can not get it. It is assumed that the following code should give me an established connection but I can not get it. <?php $serverName = "192.168.4.5"; $$connectionInfo = array(...
asked by 09.02.2018 / 17:55