Posts by harryhallerbr • 31 points
6 posts
-
0
votes0
answers51
viewsQ: $_SERVER['LOGON_USER'] equivalent on Linux
In the company where I work, there was an ISS-based PHP5 server, however it is migrating to another Debian-based Apache server with PHP7.0. I enabled the errors of the new server, and I see that I…
-
0
votes0
answers311
viewsQ: Import data from xlsx file to SQL Server
Hello, I am creating a SP to export data from a spreadsheet in xlsx format (Excel ), however I am not succeeding. My SQL SERVER is an older version of SQL Server 2000 (Build Version 8.00.2187), and…
-
1
votes1
answer43
viewsQ: Problem with Join and sub-consumption
I have an exercise to answer, however I can not get the complete solution, only partial ideas, the DBMS used is SQL Server. Considering the Customers, Orders and Order Details tables create an SQL…
-
0
votes1
answer73
viewsQ: Creation of validation with Pattern
I’m trying to create a mask in an HTML form field for functional registration, however I’m not getting it. I’m using the tag pattern HTML5. No input put the tag this way,…
html5asked harryhallerbr 31 -
0
votes0
answers52
viewsQ: Transform the rows of a column - SQL
Someone help me with the following question. Generate ".sql" extension file with script that transforms the lines of a column in a variable string, with its values separated by commas, for example:…
-
2
votes1
answer197
viewsQ: SQL SERVER odd line queries
I need to create query script that returns from the table below only its odd lines, ordered upwards: DECLARE @table TABLE (coluna1 varchar(50)) INSERT INTO @table VALUES…