Posts by w-all • 67 points
5 posts
-
0
votes1
answer3485
viewsA: Change varchar field yyyy-mm-dd hh:mm:ss to data dd/mm/yyyy in SQL Server
I believe the query below may be what you are waiting for. SELECT DATA, CAST( CONVERT(VARCHAR(10),TB_EPA.DATA,121) AS DATETIME) AS DATA_AJUSTADA FROM TB_EPA
-
1
votes1
answer36
viewsQ: Assemble query for specific scenario
I have a table with the model below (consistent data): CODIGO | INICIO | FIM 1 | 2018 | NULL 1 | 2017 | 2017 1 | 2014 | 2016 I need to find the records where the INICIO has the same value as FIM…
sql-serverasked w-all 67 -
1
votes1
answer26
viewsQ: Help with Regex in VB.Net
I’m trying to mount an expression to run in VB.Net that finds in the contents of a file the text GO. Text is always on a new line and may or may not contain spaces or tabs. I’ve come to the…
-
2
votes1
answer41
viewsQ: Regex in Javascript and C# for text validation
In an application Asp.Net WebForms, have a TextBox which I need to validate if it contains any excerpts where there are < followed by any character except blank space. For example: Nesse texto…
-
2
votes3
answers668
viewsA: Uppercase Method for Metroframework
To make life easier and not need to create the method at all Forms, you can create a new control that inherits from this TextBox that you are using and in it you include the method indicated in the…