I have been working using WPF for a while, but due to lack of resources I used Access Files as Databases. Recently I got the opportunity to get my hands on a SQL Database. When I created my WPF Application (a simple data entry, which writes and read from the database) one of the IT guys where I work started
Tag: sql-server
SQLSTATE[IMSSP]: Tried to bind parameter number 65536. SQL Server supports a maximum of 2100 parameters
I want to ask something what error is this. I want to display report book to PHP but the result showing like in picture Here is my report book: and here is the result showing in ASP.NET: Answer You need to consider the following: You need to use named (:name) or question mark (?) parameter markers in the prep…
How to print multiple value column in PHP
I have a SQL Server database about Customer information and CustomerPhone has a multiple values column which is C_Phone. This is my code: if (!empty($_GET[‘customer_id’])){ // ‘id’ input from the …
Parameterising an IN clause in PHP with sqlsrv
I have a method which selects records based on an array of integers which works when specifically typed. However, when I try to replace that array with one passed in from the method parameter sqlsrv_query() returns false. I am sure this is something very simple, but the ‘obvious’ possibilities to …
Installing pdo_sqlsrv driver in PHP 7.4 using CentOS 8
I have successfully installed php 7.4 with Remi packages in my CentOS 8 VPS (Used this guide https://www.digitalocean.com/community/tutorials/how-to-run-multiple-php-versions-on-one-server-using-apache-and-php-fpm-on-centos-8) I have a VirtualHost in my Apache server, that points to my domain and load the req…
SQLSRV skips a row when returning a query
The code above does what I want and returns number of rows that matches what the query returns. However, I hardcoded the three sqlsrv_next_result($result);. The query will change depending on @AmbassadorID, so that piece needs to be dynamic. I tried the following loop: But this loop skips the first row. How d…
PHP 7.2 – SQL Server 2017 – Create Nested Array response
I have a Stored Procedure that retrieves data from a SQL Server DB. With query result I need to populate the parameters’ Array of a SOAPClient’s Method At present I’m manually creating the Array, but …
select and count devices at a location based on coordinates of both
By using STContains function of SQL geography it was possible to calculate if a set of coordinates is within an area , however this revealed that if last received coordinates were just outside the area than these coordinates do not match any location. What would be an efficient way to display how many and whi…
SQL Server Time Format is not equal to Client Side Time format
I’m trying to compare the client side time format (“14:00”) to SQL Server time format (“14:00:00.0000000″) with SQL Query, technically is not equal because SQL Server time format has seconds and milliseconds, so I tried to concatenate the seconds and milliseconds to client side t…
Connection Could Not be Established with SQL Server 2019
I’m having a problem running my PHP project on our IIS with SQL Server 2019. My version of PHP is 7.0.26 and I have already imported SQLSRV DLLS. When I try to login with my system, the following …