Questions tagged as 'sql-server'

Tagged questions
1
answer

Applying PIVOT

I have a detail of Catalogo that is called ProductoCatalogo in which I enter the products that are going to be sold, but there are products that have their specifications as in the case of the clothes they have: Size and Color, tha...
asked by 05.10.2018 / 15:11
2
answers

How to obtain the incremental auto value in sql server 2012?

Hello everyone diculpen by this question may be something unusual or absurd, but I am looking for the autoincrementable value of a table. In MySQL it's this SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '...
asked by 14.11.2018 / 03:08
2
answers

Calculate assistances, faults, delays in PHP

I want to calculate the attendances, faults and delays of ALL the employees that return the function buscarEmpleados() from a date A and a date B which are received in $dates1 and $dates2 buscarEmpleados returns a...
asked by 06.04.2018 / 07:35
1
answer

Error in sqlsrv_fetch_array from PHP to SQL Server

In a connection from PHP to SQL server I have the following error:    sqlsrv_fetch_array () expects parameter 1 to be resource string given This is the code: $server = "SQLSERVER\INSTANCIAALABD"; $conn = array("Database" => "NOMBREDA...
asked by 11.05.2018 / 22:04
1
answer

Consult with Like to search for characters that are not within A to Z

I find myself doing a search in my database. The search consists of finding rows with characters that do not belong to the alphabet (from the 'A' to the 'Z' ) for example 'Þ' , '%' or an Ampersand ' & '. In...
asked by 31.05.2018 / 00:35
2
answers

Can I use a SQL Server database in my RAILS 4 project on ubuntu?

I want to develop a website in RAILS 4 but I must necessarily use an existing database of SQL Server, is it possible to use it in ubuntu or do I have to program in Windows?     
asked by 19.06.2016 / 07:54
1
answer

queries with sql server 2016

the statement is following: get the name and ID of the students with the highest grade in the subject with the code 46322 The structure of the database is this: alumnos (dni pk, nombre, dirección, localidad) asignaturas (coda pk, nombreas,...
asked by 19.06.2016 / 19:37
4
answers

LEFT JOIN does not return NULL values

I have two tables: AppWindowsEvent: CREATE TABLE [AppWindowsEvent] ( [idAppWindowEvent] INT IDENTITY(1,1) , [idAppWindow] INT , [idMill] INT , [idEventType] INT , [Order] INT , CONSTRAINT PK...
asked by 28.09.2016 / 16:15
2
answers

Problems reading Excel SQL Server 2012 file

The error returned by the statement is:    Msg 7303, Level 16, State 1 sql server 2012 Microsoft.ACE.OLEDB.12.0 SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0' ,'Excel 12.0 Xml;Database=\path\archivo_excel.xls;HDR=YES'...
asked by 14.10.2016 / 20:30
1
answer

BD Primary fields in varchar

Good day I have a question, I'm working with 2 databases at the same time, to make a table, it works well I did some joins and it brings me the data, but, there is a data that does not bring it to me, and I was verifying and the only thing I fou...
asked by 18.12.2018 / 16:34