Posts by Joaquim Costa • 57 points
6 posts
-
0
votes2
answers22
viewsA: New procedure is not displayed in SQLSERVER
Alternatively you can use code creation. CREATE PROCEDURE NOME_DO_PROCEDIMENTO AS BEGIN -- CORPO DO PROCEDIMENTO END;
-
0
votes2
answers85
viewsA: IF condition in Datagridview
You can put it in the eveneto click of the button: For Each dg As DataGridViewRow In DGV_LANCAMENTO.Rows If dg.Cells(0).Value.ToString() = " valor em causa" Then End I Next…
-
-2
votes2
answers586
viewsA: Write checkbox value to sql server database
Do the following: SqlCommand recebido = new SqlCommand("usp_InseriRecebimento",conexaoBDUSUARIOS(true)); chkitens.CommandType = CommandType.StoredProcedure; for (int j = 0; j <…
-
2
votes2
answers212
viewsA: Comparison between decimal numbers
You can follow what Douglas said, from the table extrusion change the data type for this field. Also you can convert from select by fetching the data using this syntax: SELECT seu_campo FROM…
-
2
votes1
answer521
viewsQ: Mysql Create a database for a single user
I want to create a database where only one user can access the information. Although there are already users created on the server, but only the user I create has to be the only one to have access…
-
2
votes4
answers118
viewsA: select dinamico
You can use this method will work: select * from tabela where nome_campo = 'campo_1' AND valor = 9 union all select * from tabela where nome_campo = 'campo_2' AND valor = 10…
mysqlanswered Joaquim Costa 57