Questions tagged as 'sql-server'

Tagged questions
1
answer

Doubt with sum of values in sql server 2008 [duplicate]

I have the query below that returns me the values of DESCONTO_PRECO and DESCONTO_PRECO_ESTADO, I would like to know if I can sum these results so that it comes in the same field. Thank you select --calculo do desconto individual ((P.DES...
asked by 23.02.2016 / 13:26
1
answer

SQL server error: local server is inaccessible

When I try to use SQL Server Management Studio 2008 I get this error:    Local server is inaccessible     
asked by 26.09.2015 / 01:22
2
answers

How to Record the Date, Time, Minute, and Second in C # WINFORMS and SQL SERVER?

I created a sales system, and I need you to record the date, time, minutes, and seconds. The way I did, just record the date, and the rest comes 00:00:00. Here is the code I did: //evento load do formulário vendas. private void Vendafrm1_Load(...
asked by 02.03.2017 / 12:30
1
answer

Configure Firewal SQL Server

How do you configure the firewal rule so that you will not be asked to update a new IP? I created an account in azure and I have a system that is under test and the server sql server from time to time I asked to update the IP and when this happe...
asked by 24.10.2016 / 11:06
1
answer

Access level layered login system

Good morning, I'm doing a course completion software at school, and I need to make a login system with access level (I'm programming in layers and using SQL SERVER 2012) . I saw a tutorial on the net that the user had to choose the level of...
asked by 06.08.2015 / 16:17
1
answer

Error accessing a server hosted on a local IIS

When I test my machine, the login works perfectly, when I share it over the network it returns me the following error:    A network-related or instance-specific error occurred while   establishing a connection to SQL Server. The server was no...
asked by 25.03.2014 / 13:54
2
answers

Listview in vb6? [closed]

I started programming with this language and would like a help on how to display data that was inserted into a textbox in a listview in vb6?     
asked by 14.07.2016 / 16:43
1
answer

List of DB clients in the program page in C #

My problem is as follows, I do not know how to make a list of users with a limit of X in a DB appear on the screen, I will try to put them into topics for a better understanding 1 - Customer list should appear every 10 months 2 - When reached...
asked by 12.01.2018 / 19:45
3
answers

Connection SQL server with angular 4 +

I would like to know how to make a connection to the SQL server database through Angular 4. I needed to know the procedures or an explanatory video. I'm an angular beginner.     
asked by 02.07.2018 / 21:11
2
answers

How to remove the decimal separator from a result?

In the sql query I have a total order value multiplied by 1000: Total value: 195.41 Value Viewed: 195410.00 How can I remove the tab? SELECT CAST (CONVERT (varchar, CAST (AS money 195410.00, 0) AS varchar)     
asked by 29.12.2016 / 14:01