Posts by Rodrigo Merce • 51 points
6 posts
-
0
votes1
answer79
viewsQ: compare Sql data with two Foreach
I’m looking for data from two tables which have an equal column, which is called the prefix column. I tried to mount a foreach inside the other foreach with the data of the two tables and comparing…
-
0
votes1
answer1228
viewsQ: How to send values with Zeros to left SQL SERVER
When trying to send values with zero on the left, when checking in the database I receive the values in zeros. Ex: 000431, appears in the database as 431. This value is being placed in the $prefix…
-
0
votes1
answer98
viewsQ: SELECT SQL Server VB NET error
Using con As SqlConnection = getconnectionSQL() Try con.Open() Dim cmd As New SqlCommand("SELECT * From Diaria where data='" & data_SQL(TextBox4.Text) & "' and prefixo='" &…
-
0
votes0
answers53
viewsQ: Error inserting data in table with column of the numeric type VB NET
Hello, I am having problems when trying to insert data in an SQL database through VB.NET. I’m migrating some vb6 projects to . net, I came across the first problem I spent the day trying to solve…
-
0
votes1
answer527
viewsQ: Query in 2 tables that have columns with the same name
Good morning, I have two tables that have the column "st", when I pull the information comes from the table st "records", I would like to pull the "st" from the table "settings". sql = "SELECT *…
-
1
votes1
answer73
viewsQ: Join SQL server
Good afternoon, I started working with sql to 3 mesês and I’m picking up on an application. I have 3 Tables which I have information associated with by "registration" I would like to get all the…