Questions tagged as 'sql-server-2012'

Tagged questions
1
answer

SQL Server 2012 - Generate query from one table to another involving 3 (three) tables at once

Hello, Community! I need help with the logic of a query I have to do in SQL Server 2012 . Well, I have three tables: [1 '] operacao_apf ; [2] operacao_contrato ; and, [3] operacao_detalhe . What I need to do: in [1...
asked by 04.09.2016 / 05:53
1
answer

How do I return the records between two values with the SQL Server Database?

Example of my table: My question is as follows ... In my news page highlight has to appear the 2 latest news and on the secondary news page have to appear the 2 other news following. Example: in the highlight the news that will appear are...
asked by 13.10.2016 / 23:40
1
answer

FormsAuthentication causes an infinite redirect error - ASP.NET C #

Good afternoon, I'm developing an ASP.NET application with C # that requires login, works and is being used this way: protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(...
asked by 14.04.2016 / 17:00
1
answer

What is the difference between OUTER APPLY and INNER JOIN on Sql Server?

What is the difference between OUTER APPLY and INNER JOIN in Sql Server ? I know how LEFT/RIGHT/INNER JOIN works however I came across OUTER APPLY I gave a read but I did not completely understand, it seems t...
asked by 22.09.2015 / 01:23
2
answers

I can not restore my backup

I made a backup once and it worked. Now more tables have been created, views w wc and I need to update the database. As the bank is in a network address and for security, we can not do anything, the manager here made a backup for me to install i...
asked by 26.09.2014 / 14:34
0
answers

SQL Server Error When converting VarChar to Integer type [closed]

FOLLOW THE ERROR Msg 245, Level 16, State 1, Line 2 Conversion failed when converting the varchar value '280-64460-2' to data type int. SQL DONE USE TOXICOLOGICO SELECT NomeUnidadeColeta, NomeUnidadeColetaAlterar, Procedimento FROM dbo.Z...
asked by 02.10.2017 / 20:41
0
answers

Mobile Report - Reporting Services 2016

This is my first post in the community and I hope to be able to collaborate with my question. I'm working on a BI project where I need to show a quantity of calls on a map, according to the models that exist ready, it's possible to use a colu...
asked by 07.10.2016 / 19:27
0
answers

Create Partition

I'm partitioning a table in my database, I created the function partition and the scheme partition. But when I go to the Create partition Wizard the Radiobutton Existing partition function is disabled even with function created. It's the sam...
asked by 05.08.2016 / 20:33
1
answer

SQL Server 2012 installation error [closed]

I formatted the note and installed windows 10, I installed SQL Server 2012 I always used, but this time it did not work. See the error: Is there a solution? The error is known as 1935.     
asked by 08.05.2016 / 02:32
1
answer

Decimal value with 5 decimal places in sql server

I am developing a (Asp.NET MVC 5.2.3.0, EF 6.1.3 e SQL Server 2012) application, the database has a table with the decimal(6, 5) field, when saving a value in this -2,56478 field, for example in the database it is -2,5600...
asked by 22.02.2016 / 21:04