I have a SQL script with a function (function drops at the end of the script) and temporary table definitions and variables to process the data that gives me on
I want to establish a MSSQL Connection from Ubunutu 18.04. It was quite hard to get this set up, but know it works so far that I can use sql_srv class or pdo cl
I am running into an issue where my .net application (C#) will not connect to SQL Server when ran by a domain user. Exception is: The underlying provider faile
I have a query with a few columns. I need to find the avg of a particular column and then use the average value to calculate other values. I am finding avg with
I have the following connection string in ASP.NET Core, but I get the following error: Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open dat
I need to migrate .SQB files to Snowflake. I have a data relay where MSSQL Server database files are saved in .SQB format (Redgate) and available via sSTP with
I am defining a new WITH statement as newStaff, and then I am taking that data and filling it into other tables. It doesn't seem to let me ref
I need to get a comma separated list with quotes and I'm almost at that point but I get a list with commas but a leading space at the start bu
I already uploaded PDF files into my SQL Server database as binary data file. I want to retrieve this file and open it with Adobe Reader on my form. Please hel
I am just starting to look at Apache Superset and wondered if anyone knows or has been able to hook SQL Server Analysis Services up as a datasource? I want to p
I am doing an outer join between two market data tables. The two tables have trading volume reported differently, therefor I need to query them separately and t
I need to encrypt SSN (nvarchar(25)) field in a SQL Server database table. Once encrypted, the Access program needs to be able to decrypt the field for user vi
I have used the count() function to calculate each of the rows values select course, count(*) course_count from student_table group by course; Without using
I'm trying to find an entity but I get a SqlNullValueException when entity framework is trying to get the value of a field that's Null. I checked in the databa
I'm using the odbc package in R, and I have an SQL Server database with a table that has a Name column that is nvarchar(max) and a PublishStatus column that is
I am attempting to do a subquery which should work but I am missing something in the syntex. I am trying: select * from (select * from (select *, row_number
Within the Job History logs - Error on Step 1 : "Culture is not supported. Parameter name: culture 3072 (0x0c00) is an invalid culture identifier." Prior to th
I have a dataset in Excel which I have imported in SQL Server. Is there a way in which when I make any change in the Excel data set like add/remove/edit rows or
The new SQL Vulnerability assessments are flagging our database with "VA1223: Certificate keys should use at least 2048 bits" (FedRAMP Benchmark). https://docs.
I have a SQL command like this: UPDATE tableName SET ColA = @ColA, ColB = @ColB, ColC = @ColC WHERE ID = @ID which is executed as the sole command in its ow
github-enterprise