Questions tagged as 'sql-server'

Tagged questions
3
answers

Doubt with record grouping

In my example, I have a query that returns 3 products as they were purchased in different orders plus I do not need this order number. So I did it this way: SELECT c.prod_pk_id, '61068276007702' as CNPJ, 'teste' AS FABRICANTE...
asked by 04.01.2017 / 17:30
1
answer

How to use an Oracle database and a Sql Server simultaneously with Entity Framework 6 in a single application?

I'm developing an application where information will be persisted in two databases, one MS SQL Server and one Oracle. I have no option to use the two banks in the same DBMS, because the Oracle database is from another application and another...
asked by 29.12.2016 / 13:09
0
answers

How to list data with inner join with mvc 5, c #, dapper, and sql server?

I have the following difficulties: 1 - View data from a select with inner join. The fields in the other tables do not all appear in the select, and those that appear have a value of zero (0). 2 - Write the data in the database. Even if you...
asked by 19.11.2016 / 01:13
2
answers

System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value to int

I'm getting this exception in C # when I try to read SQL data. I am having doubts if this error is problem with my SQL or in C #. My SQL code that does the conversion is this: '$ (SELECT ORDEM FROM TABELA UP (NOLOCK)...
asked by 20.10.2016 / 13:47
0
answers

Some doubts with Microsoft Sync Framework

I'm thinking of deploying Sync Framework to a solution I'm developing, but I've had some doubts about how Framework works, I hope you guys can help me, I'll be very grateful. The first question is: I have a local database in ....
asked by 21.10.2016 / 01:56
1
answer

SQLServer in network

I have SQLServer 2014 installed on my laptop and it is where I program in visual studio, but I also have a desktop where only visual studio is installed because I do not have much space to have SQLServer as well. My question is whether it is pos...
asked by 15.10.2016 / 10:19
1
answer

Error changing password in login system with PHP SQL Server

Good afternoon, I'm having a big problem where I can not change the password on the system. What is driving me is that it seems that sqlsrv_fetch_array works differently from mysql_fetch_array, I have a code like that using MySQL and it works fi...
asked by 06.10.2016 / 22:44
1
answer

Multiple sharing users when installing SQL Server

I recently installed SQL Server Express 2016 on my machine with Windows 10 . After a while I noticed that 13 new entries appeared in SQLEXPRESS NN format / em>, where NN ranges from 01 to 13. The image illustrates better:...
asked by 30.08.2016 / 02:38
0
answers

Fill gridview checkbox through SQL Server

I have a checkbox in the gridview and I want to load 'bit' fields in the SQL Server bd in this checkbox, that is, if it is 'True' the checkbox is 'checked'. I have this: connect = CONN(un, passwords, db, ip); String query = "select * from a...
asked by 12.10.2016 / 22:47
0
answers

How to create certificate for server in SQL Server?

I'm creating an application that uses SQL Server as the DB manager. My problem is to make a secure connection between DB and application, so I need to create a certificate on the server within SQL to be able to use as a ha...
asked by 03.10.2016 / 21:06