Questions tagged as 'sql-server-2012'

Tagged questions
1
answer

Error inserting monetary value into bank

I'm trying to save the value 137421.20 in a SqlServer table with a field of type Numeric (8.2). But I get an error with the description: "Parameter value 137421.20 is out of range." I'm trying to enter the value in the FileTracker_Total...
asked by 21.02.2017 / 21:43
0
answers

search a term in several SQL tables

I have tables with names. The "Letter A" table contains only names beginning with letter A and so on up to the "Letter Z" table. Task: Search for any name in all tables and find it.     
asked by 28.11.2015 / 13:03
0
answers

SQL Server 2012 local instance disappeared

I installed SQL Server 2012 with SQL Server Manager to interact with the database. I logged in locally, I saw db master . I disconnected (I can not remember if I rebooted the machine) but I went to enter again giving this error. Anyone...
asked by 31.10.2015 / 22:04
0
answers

Call sql server procedure via JDBC that returns cursor

I am not able to call a SQL Server procedure in java that returns a cursor. That's possible, does anyone have an example? For Oracle, you can use the example link . But I need it on SQl Server.     
asked by 02.04.2015 / 20:36
0
answers

CakePHP SQL SERVER

I have a big problem here. I have an application made in cakephp hosted on locaweb on windows server. The following problem is occurring: The save method of NO model is working. In debug I search for error of validation error and invalid f...
asked by 03.04.2015 / 14:09
3
answers

INSERT method with PHP OO error using SQL SERVER 2012

This is my Connection class in the database class Conection { private $_host = 'ALISON\MSSQLSERVER2'; private $_user = 'banco'; private $_pass = '123456'; private $_database = 'aulateste'; private $_con; function __co...
asked by 12.04.2016 / 21:27
2
answers

Error in insert with ADOCommand

In Delphi XE4, SQL Server 12, connected by ADOConnect . ADOCommand1.commandText being 'insert into tabela (a,b,c) (1,1,1)' Works as expected if a record already exists. But if it is the first record the message appears:...
asked by 04.05.2014 / 14:03
2
answers

SQL Server Function - Holidays [closed]

Good afternoon! Dear, I have the following function below that is of the days not worked that is only coming Saturday and Sunday, however, I wanted this function to include the holidays. NOTE: I already have a holidays function, however, I wa...
asked by 12.09.2017 / 22:26
1
answer

Connect SQL server with PHP

I am trying to connect a SQLServer 2012 using php 5.3 with the driver sqlsrv , however even getting connected to SQL management studio by php always return me the error    [Microsoft] [SQL Server Native Client 11.0] [SQL Server] Failed...
asked by 24.07.2014 / 01:42