Category "sql-server"

T-SQL C# CLR Execute permissions being lost on assemblies when are redeployed

I have inherited a VS2015 .NET C# project that deploys C# assemblies as CLR stored procedures to SQL Server 2016. It has worked seamlessly for many years. Howev

MSSQL 2019 Installation Problem How to solve Microsoft OLE DB Driver for SQL Server

While trying to install MSSQL 2019 ON Windows-10 I got a problem. I was almost done with the installation when this pops up: If I skip it, I won't be able to a

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrowing"

I'm using java 11, and Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Enterprise E

SSMA Column "column" does not allow DBNull. Value

I'm right now trying to migrate a Mysql db to Sql Server, I found in some forums that they recommend to use SSMA (SQL Sever Migration Assistant) but when I try

Azure Automation Runbook ADAL SQL support

I am attempting to use an Azure Automation Runbook to run a query against an Azure SQL database using Azure AD credentials: $cred = Get-AutomationPSCredential

Find highest-ranked pieces of intersecting rows in SQL

This probably falls into that "I could google it if only I knew the proper name for it" category, but here goes. I have a table of intersecting activity timefra

Convert select query results into Json

I want to execute a select query on a table and I need this result in a JSON format or in an excel sheet. I want to do this using query only and I'm using SQL S

How to automate running of Jupyter Notebook cells periodically

I want to integrate my jupyter notebook with my website, where I have written the code to fetch real-time data from MySQL server and do real-time visualisation

SQL Switch/Case in 'where' clause with and

I currently have this query DECLARE @user uniqueidentifier , @day_to_find int , @date DATETIME = getdate() SELECT @user = CAST(Value AS uniqueidentifier) F

The version of the report server database is either in a format that is not valid, or it cannot be read

I had an SQL Server 2012 database instance installed on server A. I then installed SSRS 2016 only (not the the complete SQL Server 2016) on server B but point

Inserting data into SQL Server Db An Invalid direction was specified

I am using SQL Server DB (mssql), And trying to execute Insert Query through PHP. public function registerCustomer($custId, $custData) { $sqlString = "INS

Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "xxxx"

In our SQL Server 2017 we have a linked server to a Microsoft Access file/database. There is a bunch of users who all log into SQL Server using Windows authenti

write a query to this..?

Students and Grades. Students contains three columns ID, Name and Marks, Grades-(grade,min_mark,max_mark) Ketty gives Eve a task to generate a report containin

Alphabetic ranking a list with set of 'WITH TIES - ORDER BY (multiple fields)

A regular usage of "WITH TIES" & the result of the query : Demand: The best of 10 movies as Oscar Wins SELECT TOP 10 WITH TIES F.FilmName AS TITLE,

SSIS - Set SQL query result to variable for Excel connection string

I want to set connection string using SQL Query result from my table. I need to import excel file from certain folder every month but i need to import only late

Converting VARCHAR with divide operand to INT

I have a VARCHAR which will return the value something like this '40/4'. Is there a way to convert this VARCHAR to an INT? I tried casting but it is not working

How do I define a variable based on a Case statement or If statement in the middle of SELECT statement?

I am defining the prefix of an address and then trying to remove it from the address. How can I define a variable using an if statement or case statement in the

SELECT returns NULL if run from application

I have an INSERT trigger on a view created with VIEW_METADATA. There's the following snippet: if @has_folder is null set @has_folder=(select REPLACE(REPLAC

How can we use group by keyword on PIVOT table having dynamic column joined with another table or alternative query of Pivot

I have 2 tables named tblDemo and tblSubDemo; tblDemo havve 2 columns _id and _name. tblSubDemo have 3columns, ID,Name, Demo_ID(it is the primary key of tblDemo

Failed to connect to docker hosted MSSQL

I have a problem followng [this tutorial](https://hub.docker.com/r/microsoft/mssql-server-linux/ ) where I try to connect to my docker hosted MSSQL via sqlcmd.

Other Categories