Questions tagged as 'sql-server'

Tagged questions
0
answers

Replication of tables with different databases

Hello, I have a database in sqlserver and an application with mysql database, I would like to know if there is a way to synchronize a table in both banks. Example: there is the table "mytable" in sqlserver, I want everything in it to be reflected...
asked by 04.10.2018 / 21:37
0
answers

The app quits unexpectedly when I run the bank

I made an application in Android Studio that inserts some registration data into the sql server database. When I give a send, the app closes unexpectedly. package imports public class ConnectionClass { private String server = "meu servid...
asked by 29.09.2018 / 03:18
0
answers

Trigger in sql server management studio

I would like to create a Trigger in MSSMS (Sql Server) which, if I made an INSERT on a table A, with the last record of table B, it inserted 10 more records in table B, and so on every time I used the last one created another 10. But I do not kn...
asked by 25.09.2018 / 20:27
0
answers

Change the order of an XML tag via T-SQL

Hello I'm having a demand where for a certain reason, XML was generated with the order of the tags exchanged ...: ( Scenario: I have a column in the SQL Server database (from the 2008 release) that contains NF-e XML saved from a Windows app...
asked by 21.09.2018 / 16:47
0
answers

Comp remove Special characters?

I have a problem with a report from Pentaho, prd. It does not generate the PDF report because of the amount of special characters. I wanted a way in the sqlserver to remove the characters without losing the formatting of the text. Because the te...
asked by 16.09.2018 / 19:14
1
answer

Restore a SQL SERVER database from a mdf file

I need to restore a database from an MDF file. I got the mdf from another machine to be restored on a main machine. When attaching, attaching the MDF file, an error occurs saying that the file can not be located, but the address of the displa...
asked by 18.09.2018 / 20:35
0
answers

Columns of sql server tables are not recognized in php

I have columns that were written to the sql server with a capital letter, when I get it in php, I need them to recognize both lowercase and uppercase. For example: select * from rzv_aluno records: AL_NOME, AL_EMPRESA... etc In php I...
asked by 11.09.2018 / 22:44
2
answers

Trigger with null value

Good evening guys, I need to make sure that the address and phone columns are null, in case an error message is returned, otherwise the operation will take effect. my code looks like this: CREATE TRIGGER VERIFICA ON cliente INSTEAD OF INSERT A...
asked by 06.09.2018 / 00:54
1
answer

Return of a Stored Procedure

I have an X action in my application which, when it is executed, triggers a stored procedure in the database that generates a insert in a table. So far, so peaceful. What I'm needing is a way that when this stored procedure is exec...
asked by 29.08.2018 / 14:06
1
answer

Query in 2 tables that have columns with the same name

sql = "SELECT * FROM configuracao b LEFT JOIN dividas a on (b.registro = a.registro) and (b.empresa='" & Left(Combo1.Text, 2) & "') left JOIN registros r on (b.registro = r.registro) and (b.empresa='" & Left(Combo1.Text,...
asked by 24.08.2018 / 13:50