Questions tagged as 'sql-server'

Tagged questions
1
answer

Doubt Case SqlServer

I'm using the following case: CASE WHEN RESPOSTA.CD_RESPOSTA = 1 THEN 'ATENDE' WHEN RESPOSTA.CD_RESPOSTA = 2 THEN 'NÃO ATENDE' ELSE 'NÃO APLICÁVEL' END AS DS_RESPOSTA I have the value of ANSWER.CD_RESPOSTA: 2. The field is an I...
asked by 29.05.2018 / 15:54
0
answers

Error - Power BI connection with SQL Server

I'm trying to connect power bi with my sql server database, however, the error below is occurring. NOTE: TCP / IP and Name Piper are enabled on the SQL server. These were the database connection data. Server: 122.122.122.122 \ MSSQLS...
asked by 01.06.2018 / 14:15
0
answers

Connect SQL SERVER database to external server with application in Notebook

I have a SQL SERVER database hosted on Locaweb. However to develop I need to connect this bank to the Site that is locally in my notebook. The Site System is in ASP CLASSIC. I made the ODBC connection on the machine and changed the connect...
asked by 30.05.2018 / 20:28
0
answers

Column type is not supported. Type is 'Object' - DataTable

I am wanting to pass a DataTable as a parameter to a procedure, this DataTable comes from an Excel spreadsheet that is then converted into a DataTable. In SQL I created a Type Table with the required fields, all columns with the same name as...
asked by 23.05.2018 / 23:08
0
answers

Local Database .MDF C # Visual Studio 2017 (CONNECTION)

I'm developing a windows application using visual studio 2017, however I came across a problem, on my machine I'm doing the project everything runs right, on the other machine that tests the connection error with the bank, I already installed th...
asked by 24.05.2018 / 06:18
0
answers

Web-API display problem with tables with relationships

Good morning, people, I am developing a WEB API to be consumed in a mobile application using Xamarin, I am transposing the classes directly from the database with the code first of Visual Studio, however when I try to generate a simple view o...
asked by 22.05.2018 / 15:25
1
answer

Define which value will be stored in a PHP variable to be saved in the Bank

I have an HTML page where the user selects the information he needs and stores it in the database when he completes the operation. It's a small form in which virtually you only have check boxes in except a single text box. In one of the checkbox...
asked by 22.05.2018 / 13:50
0
answers

xp_cmdshell how to put folders that have space?

I put a folder in the terminal exec xp_cmdshell 'dir b:\teste\*xlsx*' exec xp_cmdshell 'dir b:\teste teste\*xlsx*' When I add space it does not find. It is not possible to change the name of all folders that have space because there are sev...
asked by 16.05.2018 / 17:41
1
answer

Call other data from an entity

I created a database entity and a dropdownlist. When I click on a list item, I want to call the other data. How do I do it? Follow code public ActionResult dbExample() { copaDBEntities entity = new copaDBEntities();...
asked by 14.05.2018 / 20:26
1
answer

Connection Sql Server Bank .MDF does not work C #

My application error when I try to run on another machine, except that on this machine I have nothing from sql server installed, what do I need to run my application on any pc? The following is the error: System.Data.SqlClient.SqlException...
asked by 23.05.2018 / 00:25