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
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