Posts by Lucas Vasconcelos • 199 points
11 posts
-
0
votes1
answer82
viewsA: Compare different value, value "null" does not enter the resutaldo
What kind of camp? It was really only supposed to work with AND tipo_documento IS NULL.
mysqlanswered Lucas Vasconcelos 199 -
1
votes2
answers2812
viewsQ: Decimal variable removing decimal places
I have a variable in decimal which receives a value of a textbox, but when this variable receives the value with decimal places it removes the decimal place and stores the value without the same.…
-
3
votes3
answers2241
viewsQ: How to create nonexistent columns in a Datatable?
Here is my query: select u.nome as analista, s.descricao as situacao, count(*) as qtd from tb_projeto p inner join tb_usuario u on u.id_usuario = p.id_usuario inner join tb_situacao s on…
-
2
votes1
answer84
viewsQ: How to restrict some BD iterations?
Explaining the title: I have a table called projects, these projects can be approved or disapproved. Each insertion or update of a record in the project table is saved in a history table (e.g.: I…
postgresqlasked Lucas Vasconcelos 199 -
1
votes1
answer1537
viewsQ: How to open a file that is within the solution with Process.Start
I added my solution in C# a folder called "files" inside this folder will be placed some standard documents that can be analyzed when registering some projects. I have a combobox in the form for the…
-
0
votes0
answers43
viewsQ: How to OPEN a file that is in an array of bytes?
The situation is as follows: I have a database where I store some files in bytes array (these files are OUTLOOK E-MAILS of the extension .msg). The purpose of this is nothing more than this: When I…
c#asked Lucas Vasconcelos 199 -
0
votes2
answers2442
viewsQ: How to read and open files from a byte column in SQL Server?
My question is the continuation of this question: Link to the other question I managed to transform my file into bytes and insert it into a table in SQL Server, but now I want it from inside an…
-
1
votes1
answer3350
viewsQ: How to save a file to a field in SQL Server?
I would like to know how to save a file within a SQL Server field com C#. Reading on some forums I realized that there is difference between image and binary files. The type of file I want to save…
-
1
votes1
answer114
viewsQ: Restrict a character limit array in the LIKE
I have a question about the LIKE of T-SQL. Is it possible to restrict by a number of equal characters to check how many addresses start equal and can end different? Sort of like this: Where Endereco…
-
3
votes1
answer71
viewsQ: Error restricting dates in SQL Server
I get 3 databases that are mounted in different locations, these bases come to me in text file (.txt) and I import to SQL Server. I’m making a query in which I want to restrict the records only for…
-
5
votes3
answers1405
viewsQ: How to export SQL records without duplicates?
I’m trying to remove some duplicate records from a table and I searched the Internet for how to do that, and I found something about distinct. My scenario is: I have a table that has a record with…