Questions tagged as 'sql-server-2014'

Tagged questions
1
answer

how to create a SQL table with dynamic columns

How can I make a dynamic SP where according to the data of a table1 I take them as columns to create a table2 these may vary . That is to say how there can be 1 or 2 there can be 10,20,30 ... I leave a SP to create a table CREATE PR...
asked by 13.04.2018 / 21:40
0
answers

Appropriate permissions to system tables in SQL Server for reverse engineering in java hibernate

Which SQL Server 2014 tables should be given permissions for reverse engineering to work in the java hibernate framework? I've been getting this error in eclipse: com.microsoft.sqlserver.jdbc.SQLServerException: El nombre de objeto 'INFORM...
asked by 10.04.2018 / 01:40
0
answers

Error loading data from one table into another - SQL Server 2014

I have the following stored procedure which I use to fill the Resources table. To load the Resources table, I get the IdEntity that I bring from a datagrid that contains a list of accounts. The problem is that when loading the data in the Resour...
asked by 13.03.2018 / 16:59
1
answer

Generate tags with zk framework from java

I hope they are the best, the problem I have is that I want to generate a menu in zk framework, but I want to generate the data from java. The problem is that I do not know if what I formulate serves me. I need help, apart from that I do not kno...
asked by 15.03.2018 / 00:16
1
answer

problem installing Microsoft SQL Server 2014 CLR Types 32bits

before installing reportviewer asks me to install Microsoft SQL Server 2014 CLR Types of 32bits, I have the 64bit that works perfectly on a 64bit machine     
asked by 06.02.2018 / 23:22
1
answer

Error running Prodecure - Data types GEOMETRY - SQL SERVER 2014

Good afternoon, Create a Procedure that verifies if a point is inside or outside a Polygon. I have a polygon table and a point table (Float) I do all the conversions due. To be able to do it, use the GOEMETRY data types. When I ex...
asked by 13.12.2017 / 21:20
1
answer

Warning: Invalid argument supplied for foreach () PDO / SQLServer

Greetings, I have a code that is giving me problems with a foreach and I have not achieved its correct operation, it is a query to a database SQLServer with PDO ODBC, I have tested the queries separately in PHP and it does not give...
asked by 28.12.2017 / 14:59
0
answers

Android application does not run on API 19

I'm starting to develop on Android and use the IDE Android Studio. I have an app that connects to a database with SQLServer, the only thing it does is make a query that receives 4 fields by sending it 1 ID. The App is already ready and I have fi...
asked by 25.09.2017 / 01:32
2
answers

Xampp SQL server 2014 PHP 7.1.9

I have a xampp running with PHP 7.1.9. I use the sql server 2014. But now I need the drivers for PHP. I can only find a version that supports 5.5, 5.6 ... ( link ) Is there a way to let this work with PHP 7.1.9?     
asked by 27.09.2017 / 10:08
1
answer

Stored Procedure to concatenate a varchar and an incremental integer in fields with repeated data - SQLServer [duplicated]

I need to edit the name of a field (in case it already exists) of my table in my database in SQLServer 2014. • If the @pNameTarea parameter is NULL or empty, an automatic Name is created, this YYMMDD being created and if there is a Task with...
asked by 14.08.2017 / 14:48