Questions tagged as 'sql-server'

Tagged questions
0
answers

Conflict between tables in sql servre 2012

I have a problem when making a relationship between two tables in sql server 2012. How can I resolve this? Table 'tbl_chkrecebbing' saved successfully Table 'tbl_chkitens' - Can not create 'FK_tbl_chkitens_tbl_chkrecebimento' relationship. T...
asked by 25.07.2018 / 21:45
0
answers

Error creating Linked Server with MySQL

I am trying to create a Linked Server in SSMS to access a MySQL database. I installed and configured the driver to make this connection, it tested and it worked normally, but at the time of creating the linked server, I am getting the error belo...
asked by 02.08.2018 / 17:06
1
answer

Convert to decimal without adding zeros - SQL Server

I am converting a number from varchar to decimal. This number already has the boxes after the comma, and when converted it adds two more zeros. Example: 12,345.67 --- > 1234567,00 The code I am using is this: CAST (REPLACE (REPLACE (ZMI...
asked by 11.07.2018 / 21:33
1
answer

How to add equal amount of SQL?

I have the following query: SELECT DISTINCT CTRL_CARGA_PED_VENDA.CtrlCargaNum, ITEM_PED_VENDA.PedVendaNum, PRODUTO.ProdCodEstr, PRODUTO.ProdNome, Sum(ITEM_PED_VENDA.ItPedVendaQtd) AS QtdItem FROM ITEM_PED_VENDA, CTRL_CARGA_PED_VENDA, PRODUTO...
asked by 11.07.2018 / 22:18
0
answers

Special characters breaking XML in SQL SERVER

I recently had a problem reading an XML, where the value of the field seems to have a special character. Below is the snippet I created for the problem declare @xml as xml set @xml = '<ConsumerList> <Consumer> <Sourc...
asked by 10.07.2018 / 20:52
0
answers

WHERE failed to associate a column to query in a view

I'm passing some parameters to a view where I need to get the return of this query. When defining the filters in the Where of my query, the query return reports the following error:    Invalid 'competition' column name. I know it's my cod...
asked by 10.07.2018 / 20:22
1
answer

Lock log in SQL Server

Using SQL Server and Delphi, I need to control so that in a certain database table two changes can not be made at the same time in the same record, I can not start the update if there is already another change in progress. I need to know if this...
asked by 10.07.2018 / 15:01
0
answers

Sql Reporting Services: Two WebPortal URLs

I'm trying to parameterize another URL to use Reporting Services but the following happens. I add the URL below: TheoriginalURLparameterizedintheinstallationworksperfectly: Icanaccessnormally ButwhenItrytoaccessthenewonetheerrorbelowappears...
asked by 04.07.2018 / 16:42
1
answer

PYMSSQL - error

Personal I'm having a problem with the pymssql library, whenever I try to make a connection it has the following error: Thisistheconnectionstr:importpyodbccon=pyodbc.connect("DRIVER={SQL Server};server=localhost;database=teste;uid=sa;pwd=Tes...
asked by 02.07.2018 / 22:25
1
answer

Image Upload Using PictureBox - windows forms

Say hello, good morning! I'm not sure how to do this, but I'm not sure how to do this. and I'm making a photo using photo! however when doing the insertion of the data and converting the photo to binary in my database my statement returns this e...
asked by 03.07.2018 / 14:45