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
All, How can I check if a specified varchar character or entire string is upper case in T-Sql? Ideally I'd like to write a function to test if a character is u
I've been facing an issue for a few hours, and I can't seem to get my head around this one. So I have a SQL Server database 2008R2, Collation SQL_Latin1_Genera
I am trying to solve the below problem, I have an existing dataset that is already grouped, but I need to it to be grouped further based on the common "SO_Numbe
I'm having some issues with the connection with Java and SQL 2008 Express. I'm using sun.jdbc.odbc.JdbcOdbcDriver driver for the connections and have created my
I'm trying to average a set of columns and exclude rows with zero from the denominator by using a case statement within an AVG() function. I read that avg() exc
I am using SQL Server 2014 and I am running the following UPDATE query: UPDATE ReservationStay SET ReasonForstayCode = b.ReasonForStayCode FROM MissingReaso
There is a special base table type in my DbContext. And when inherited from it I need to generate an additional "SQL" migration operation to create a specific t
I want to connect Laravel (version 8), with a SQL Server database (SQL Server 2008 R2). I've done the installation and followed some tutorials with steps like t