Questions tagged as 'sql-server'

Tagged questions
2
answers

SQLSTATE [08001] - Named Pipes Provider - Laravel

I'm getting an error when connecting to the application with the bank. The .env file is configured correctly with the bank settings, the error that I have in return: SQLSTATE[08001]: [Microsoft][ODBC Driver 11 for SQL Server]Named Pipes Pro...
asked by 13.12.2017 / 17:33
1
answer

How to remove a SQL Server constraint

I'm having a problem removing a constraint from a table. Purpose is to exclude the constraint to delete a table. The problem is: I have a Yield table that is associated with Extra Yield. This Yield table is FK_COD_RENDA_EXTRA. ALTER TAB...
asked by 26.12.2017 / 18:13
2
answers

Select all customers and check if you are carrier and supplier

I want to make a select that selects all the clients and next to it create two columns a carrier call and another provider and in each of them to mark yes or no. Ex: Código Nome Fornecedor Transportadora 01 João Sim...
asked by 06.09.2018 / 22:35
1
answer

Create new table from another in sql server

I'm doing this query : CREATE TABLE nova_tabela AS SELECT * FROM tabela_copiada; I'm getting the following error :    Incorrect syntax near the keyword 'SELECT' I already searched the syntax and I think it is correct. Can anyone he...
asked by 09.01.2018 / 19:34
2
answers

Insert Select Sql Server

Connection and Historico_ligacao I have a script that copies all data from table Ligacao to Historico_ligacao . When comparing the data between the tebalas, the historico_ligacao table is ordered differently th...
asked by 04.12.2017 / 19:52
2
answers

Insert multiple items with the same Sql sever Sql

Hello How can I insert multiple items into a single ID Primarykey autoincrement There will still be columns of IDproducts where I want to insert multiple items into a RequestID as I do so I've tried with update plus it will override the pr...
asked by 02.11.2017 / 18:24
1
answer

SQL Server - How to create a new table using a select from another table (both in the same database)

I made a sql script by joining some tables in SQL Server and I will have the result in some fields, but I would like to create a new table and copy everything I have filtered with select into it ... Something like: create table Enderecos_new as...
asked by 16.10.2017 / 22:29
1
answer

SQL Network Database Communication

I have an application that works perfectly with BD on a notebook. But I would like to be able to access this database through another device. So I thought about doing this communication over the network. But I happen to know nothing about net...
asked by 09.10.2017 / 16:39
2
answers

Doubt - SQL Server Query

How do I get the sql server to get the records longer than 10 days from the current date, ie in the current month, I want to get all the records prior to 01-08. I tried it that way, but it did not return anything. SELECT S.SolID [Chamado], UC....
asked by 10.08.2017 / 19:55
1
answer

Configure sql server without instance

I use SQL Management Studio to run queries and the installation has been configured to use with INSTANCE. How do I remove this instance from the configuration or use a default? The instance I have configured is SQLEXPRESS.     
asked by 03.08.2017 / 16:24