Questions tagged as 'sql-server'

Tagged questions
2
answers

What this error is in PHP with SQL Server

Hello! After a long wait at the end, I have to develop a system using Yii2 and SQL Server . I downloaded XAMPP with PHP 5.6.31 and I installed SQL Server 2008 and I can not connect to the database. I have already tried down...
asked by 01.03.2018 / 14:04
1
answer

Problem when joining SQL tables

I have a query: SELECT p.id, resultado, (count(resultado)*100)/(SELECT COUNT(*) FROM IAssesment_Evaluaciones WHERE area='TlP/LOP2.1') count FROM IAssesment_Evaluaciones e INNER JOIN IAssesment_Resultados r ON...
asked by 09.04.2018 / 14:45
1
answer

C # IndexOutOfRangeException?

I'm doing a login in C# and SQL Server , with a table that I just created. In this table, I store the passwords of the users with a hash SHA2_256 . When making the login, I use this code: var.User = txtUser.Text; var.Ps...
asked by 13.04.2018 / 20:04
1
answer

Publish WPF project with database in SQL Server

Good, I have a project that I did in visual studio (WPF) and that is already "finished", this project connects to a database I did with SQL Server Management, my question is how can I "publish" or create an .exe file of this application to be ab...
asked by 17.01.2018 / 18:09
2
answers

JOIN SQL MULTIPLES TABLES

Good morning, I would like to ask a question, this sql query is working, but repeat the records, any suggestions or corrections select f.periodo 'PERIODO_INFORMADO', s.rut_emp 'RUT_EMPRESA', e.nom_empresa 'DESCRIPCION_RUT',r.id_reg 'REGION...
asked by 17.01.2018 / 13:42
1
answer

Check hour of entry and exit of employee night shift in sql

I appeal to you for support and suggestions. I have the following table in SQL: It is the record of entries and exits of employees that keeps a clock, as you will see it is not possible to differentiate inputs from outputs since everyth...
asked by 22.12.2017 / 23:16
2
answers

CAST and CONVERT rounded a float by passing it to varchar - SQL SERVER 2014 - Microsoft SQL Server Management Studio version 12.0.2269.0

Good afternoon, I have a problem when I take the float values from a sql server database and convert them to varchar with CONVERT. This function, I round the float and then it turns it rounded. The same goes for CAST. I need the varchar to be a...
asked by 06.12.2017 / 16:33
1
answer

Differences between FETCH ABSOLUTE and FETCH RELATIVE

I am working with cursors whose behavioral parameter is SCROLL but I do not understand what is the objective of two of its functions when it comes to making the FETCH . I do not understand what they do or what they serve FETCH AB...
asked by 14.06.2018 / 10:47
1
answer

Is it possible to generate consecutive ones based on the change of a column in SQL Server?

I have this case: I'm interested in SQL Server 2008, to be able to assign a row to the records but to reset it to 1 every time a date changes in the query. For example I have these data: And I am interested in generating a consecutiv...
asked by 01.12.2017 / 22:25
1
answer

Error using bcp command with xp_cmdshell

I am trying to use the command bcp by means of a query with xp_cmdshell the problem when executing it I skipped an error of Unable to open the file. But if I execute the same by command lines it works perfectly. The user I'm using has sysadmin p...
asked by 16.11.2017 / 08:49