Best answeres tagged with sql-server

0

answers

Problem with InvalidOperationException

I am creating an application, this is being developed with WPF, the functionality of that app is to create a database in SQL Server through the code, since I made their respective properties in the Model and ModelView it is also worth mentioning...

asked by 03.09.2018 / 02:18

0

answers

Use of reports in VB.NET

I have to change the reports from Crystal Report to PDFsharp & MigraDoc, the bad thing is that I can not find documentation regarding the use of queries. For example: -> Crystal Report Protected Sub btnVerFichaDet_Click(ByVal sender...

asked by 06.09.2018 / 09:47

0

answers

When I consult an SP with PHP-SQL Server-PDO and use output variables plus set of results. The variables return empty

I'm having two problems so to speak with PHP - SQL Server . I am trying to work stored procedures with PHP using database SQL Server . I put the code PHP with PDO : $opciones = array( PDO::ATTR_PERSISTENT => true, PDO::...

asked by 30.08.2018 / 23:02

0

answers

Problem with XAMPP / dll file

I have installed the XAMPP on my computer and a while ago I had to work with SQL Server, investigate in Google to be able to add SQL Server extensions to work with PHP and install everything right up there. Now I had to work with another comp...

asked by 29.08.2018 / 18:39

0

answers

How to audit the name of the affected column, the previous value and the new value with a trigger dynamically?

I have a table to audit: Tabla Tabla ID, col1, col2, col3, col4... col500 If you make update in Tabla my trigger is triggered which inserts in the table Tabla_audit Tabla_audit ID, ColmunaAfectada, ValorAnterio...

asked by 30.08.2018 / 02:11

0

answers

Warning: mssql_fetch_row () expects parameter 1 to be resource, boolean given - SQL

I do not know if you can help me or my question is not understood, I leave it to you in the same way, I have the following error: Warning: mssql_fetch_row () expects parameter 1 to be resource, boolean given in usr / home / FFFF / paymen...

asked by 04.09.2018 / 21:05

0

answers

Divide records by a column in a SQL Server view

I'm working with a view in SQL Server and I currently have the following: I get in a row the sum of the allocation of hours of the employees and the machines for each task. Example of a record: 0ba22dd5-0041-4a85-91622bc6f-3213-46c...

asked by 28.08.2018 / 09:29

1

answer

Substring of a SQL Server txt

asked by 23.08.2018 / 18:01

0

answers

how to optimize this function with union all

I use all those tables depending on the u_lgs_type this function I use in a procedure ALTER FUNCTION [dbo].[SBO_FN_LGS_OBT_OBTENER_tipo_cambio](@Codes int) RETURNS varchar(250) AS -- Returns the stock level for the product. BEGIN...

asked by 24.08.2018 / 16:19

1

answer

Group by en with Subqueries Sql SErver

I would like only 3 count only the amounts select ( select count(DISTINCT concat(U_codpro,U_codemp)) from [PE_SBO_BSH_ELECTRODOMESTICOS_SAC].[dbo].[@A1A_RSPC] where U_codpro = '201803EMP') as [a], ( select count(DISTINCT concat(U_codpro,U_code...

asked by 29.08.2018 / 05:48

Questions tagged as 'sql-server'