Questions tagged as 'sql-server'

Tagged questions
1
answer

SQL Bank Log in Restoring Pending

I have a SQL database that was accessed by someone else and it went into "Restoring Pending" as soon as they accessed it. Is there any way to extract some log or any other more detailed way of knowing how, who and when it was done?     
asked by 03.07.2018 / 15:46
1
answer

Catch only the values that are different in the query

I made a query that brings the values of credit and debit, but I need to bring only the values that are different from these two fields. At the moment I do not know why he is bringing everyone. Look at the image: OBS IS IN SQL SERVER sq...
asked by 02.07.2018 / 15:31
0
answers

Change Log-SqlServer Audit

I have a windows forms application and want to create a change control of the registers, a log where the value of the previous and current field is registered, date and user that changed, as well as insert and delete. Searching on the internet t...
asked by 27.06.2018 / 17:30
0
answers

Remove fixed lenght from SQL Server

The string fields of the tables in my database are coming with fixed length as true. So if the size is 60, and I saved a string with size of 30, it fills the string with spaces up to the full size. If it is in edmx and set manually to false it w...
asked by 30.06.2018 / 20:33
1
answer

How do I return a random value from my database already displaying on another tab?

I want to return a random value from the bank and already display in another tab, through a function. For when I click on send already calls this function. Controller public ActionResult RetornarVideoAleatorio(int id) { var lis...
asked by 04.09.2018 / 01:07
0
answers

Query sql with reserved word in column name [duplicate]

     This question already has an answer here:                   A MySQL query with 'ciphers' vs without                                      2 answers                                                 Mysql reserved keywords        ...
asked by 22.06.2018 / 22:07
0
answers

Error in SQL Server Data Migration to Oracle

I have a problem migrating the data that is in SQL Server to Oracle, using that "Migrate to Oracle" tool in SQL Developer, where it associates the data between the involved banks through a repository. > Then in the execution the data migration...
asked by 21.06.2018 / 19:33
1
answer

How to display data from a SQL Server query using PHP?

I'm trying to display data from a table in my SQL Server database using PHP, but I'm not getting it. The code does not error but also returns nothing. The code is this here: <?php $serverName = "MIRCIA-PC\PRIMAVERA"; $resultadoectionInfo...
asked by 16.06.2018 / 18:55
0
answers

SSAS Process.Add Calculated vs. Non-Calculated Partitions

I was trying to Process.Add my SSAS Database via TMSL following the instruction of this URL: ProcessAdd with TMSL Script    The JSON DDL request failed with the following error: Failed to   execute XMLA. Error returned: 'A Refresh reques...
asked by 20.06.2018 / 14:35
1
answer

Alternative to SQL Server Compact Edition

Up to the older versions of Visual Studio, the option to create a local database ("Local Database") was available. However, in the 2017 version, there is no longer this possibility. Apparently Microsoft would be removing support for it. Would...
asked by 24.06.2018 / 16:49