I am working on an app that is providing a way for an user to define a SQL query and run it against the database. The only purpose of the query is to create a d
PHP has removed support for php_mssql.dll support for versions starting with 5.3. For that reason I have been using version 5.2 till now. But ionCube which conv
I am working with healthcare data that comes from a table that only has one column for procedure code billed, but multiple lines of transactions for each claim
I have a host running Windows 10, WSL 2. My guest is Ubuntu. I'm trying to use sqlcmd to connect to the SQL Server running on my host machine, but I'm not sure
I want to run SQL Server queries on a Dynamics 365 database. The administrators of the Dynamics database have enabled "TDS" for me - and now I can easily connec
I have local and a linked server tables in SSMS local [Arc].[dbo].[Record] linked server SQLSERVR.[ArcReport].[dbo].[RecordRemote] when I query select * from [
I am receiving the following error when trying to execute an SSIS package using Visual Studio 2012: Error 39 Microsoft.SqlServer.Dts.Runtime.DtsRuntimeExce
I am trying to use the contains operator with FORMOF INFLECTIONAL, but I'm not getting what I think is the expected result. Here is the query. This query is no
I'm new to MVC so I hope to get help regarding my question. I am making users upload images. the image path will store in the database but the image itself will
We have a azure hyperscale sql db. We want to restore it to general purpose. Is anybody know to restore azure hyperscale sql database to general purpose databas
My current setup is as follows: Client Javascript JSON stringified object is passed to a server function as so Client: var requestObject = JSON.stringify(cli
I'M wondering myself whether am I the first programmer struggling with this problem, but i can't find anything in SO about this. Point of my
We migrated our servers from 2005 to 2014, User is able to delete it in the 2005 server But in 2014 we are getting the error as do not have permission or does n
I tried to restore a database but this message showed. How do I restore this database? Restore of database 'farhangi_db' failed. (Microsoft.SqlServer.Mana
I need to design a windows application which represents multiple "customers" in SQL Server. Each customer has the same data model, but it's independent. what w
We are using Always encrypted in a .Net core application. The Sql Server database is maintained with EF-core migrations. I was wondering how to propagate the co
We are using tSQLt for unit testing our database and executed below: EXEC tSQLt.Run '[testComplianceDimensions].[test CountOfPropertiesWithLatestRepairJob]' EXE
So I have a query like this Create Procedure sp_GetTotalTargetsCount @userId int AS Begin Create Table #RequestTargets ( Name varchar(20), Value int ) Declare
I am trying to get a cell drop-down values in Excel from a SQL Server. I don't want to use the method of putting all the data to another sheet and the use data
Here i am new in Developing the SSIS package I need your support to come up with the solution. I have 10 different set of stored procedures which I have to ex