Questions tagged as 'sql-server'

Tagged questions
2
answers

The conversion failed to convert the varchar value 'No' to the data type tinyint

I am trying to solve an error I think of converting a variable created by me to store data that is in an Excel sheet. The error happens when I try to insert the data that is in this variable in the SQL Server , that is in the (query)....
asked by 03.03.2017 / 18:11
1
answer

An exception of type 'System.OutOfMemoryException' occurred in mscorlib.dll but was not handled in user code asp.net

I'm having trouble getting this error resolved. My purpose is to collect data from an Excel file storing it in C # variables, which in turn will be inserted in SQL Server 2012. Reading is done line by line. Here is the code where the error happe...
asked by 24.02.2017 / 10:50
1
answer

Difference between Users and Logins

In SQL Server we have the option to create logins and database users a>. What's the difference between the two?     
asked by 17.05.2017 / 15:47
0
answers

Display image in Excel using binary code

I have a report on Excel where data is displayed through stored procedure . I have a problem because when I look for the value of the image field that is blob , it displays the binary code in the report instead of the image...
asked by 09.01.2017 / 02:56
1
answer

Multiquery PHP PDO - SQL Server 2012 - IIS 8.5

Is there a problem in running multiple queries with the same PHP PDO code? Example: <?php // Retorna $con include 'conexao.php'; // Suponhamos que dbo.minha_tabela tenha apenas três campos, sendo um deles a chave-primária auto increm...
asked by 11.01.2017 / 19:04
1
answer

PHP SQLServer Stored Procedure Does Not Run Correctly

Hello, I'm developing an application using Laravel Framework Handler from my Backend and found the following error. My SqlServer Express 2008 R2 database has a stored procedure that performs a series of routines and inserts data already forma...
asked by 19.12.2016 / 16:34
1
answer

Insert Error with FK

I have two tables, Client and Plan, which have the 1:1 relationship. I have 3 plans registered in the bank with their respective data. But when trying to insert a Client that has a Foreing Key that is referring to Id of the...
asked by 21.12.2016 / 21:23
0
answers

RDS Amazon recognizes Brazilian time as Manaus UTC-04: 00 and not Brasilia UTC-03: 00 [closed]

I'm starting to use AWS services and I came across a "problem" in Amazon RDS. I use Sql Server and it updates its time according to the time of the server, but when I select the time for my time zone UTC-03: 00 (greenland on the RDS server) it...
asked by 20.12.2016 / 18:50
0
answers

ENTITY truncating decimal value when doing SELECT

I have the following situation, When executing a query using LINQ, I have the following return 5178560,00 but if I run the same query, directly in SQL SERVER, it returns me 5179975,00 . It is not a display problem ... it already brings...
asked by 17.02.2017 / 19:59
4
answers

Select with several Left Joins Sql Server

I have taken an example of a people register with the following structure: I'mtryingtomakeaSELECTintblPessoawithJOINwiththeintentionthatselectreturnsthedataofthetableinwhichtheIdexists,selectselect:selecttblPessoaJuridica.Nomeas[NomePJ],tblPess...
asked by 26.01.2017 / 21:28