I have manually added the column IdCategory to my table Books, and now each time I try to run Update-Database, I get this error: fail: Microsoft.EntityFramewor
As far as I know, uploading images to databases is wrong, but in this specific issue, I have to upload images to SQL Server. I found some results, for example u
I'm getting this error from SQL Server on SSMS 17 while running a giant query: Conversion failed when converting the ****** value '******' to data type ****
Does anybody know what is the limit for the number of values one can have in a list of expressions (to test for a match) for the IN clause?
trying to connect with MSSQL server with windows authentication using reactive(R2DBC) JDBC driver #Data Source Configuration spring: r2dbc: url: r2dbc:mss
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