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
I am trying to output data from 2 different tables in my database which are joined by a junction table. Table 1: musician Columns: musicianID, surname, fName
I have been working on reports in Sql Server Reporting services and I am trying to create a tabbed report. I wish to have a main report which read in parameter
I am trying to debug an SSIS package locally, but for some reason the connection manager is offline and it can't be changed. Have anyone faced this issue before
We are using a trial version of Azure. We are trying to perform cross server queries from our SQL Server 2012 in-house. We seem to have our local 2012 linked wi
Is it possible to have fully dynamic SQL Stored procedures? I've read up on dynamic SQL for the past few hours but couldn't find the "fully dynamic" solution th
I need to do an Select on a table that has many records to mask the Account Number. Example AccNumber : 123400012341234 Output result should look like 1234000
Is it possible to write a statement that selects a column from a table and converts the results to a string? Ideally I would want to have comma separated value
I want to read data from an SQL Database in my VBS Script. My problem: I need to logon with Windows Authentication and not with an SQL Account. But I cannot use
I need to import great amount of data from excel into MS SQL Server, using the Import/ Export Wizard. Then I'll continue importing more data into the same table
I have two databases (firstDB and secondDB) on MS SQL server. There is procedure [dbo].[MaintaineIndexes] in firstDB and DatabaseEventsTrigger in secondDB. I wa
I am struggling to find a solution for the below issue. date1 = 31-08-2017 12:10:00 I want to cast it as string and need to take date (31-08-2017) alone. Th
My SQL Server instance has a linked server to an Eloquence database. I need to select data from one of the tables in the Eloquence database, but I need to do i
I have created an external table in Azure Synapse from a parquet file stored in an ADLS Gen2 container. I have used the following three queries to create the da
I've got two foreign keys in a table. Let's assume that table is called News and has foreign keys updatedById and createdById, both of which point to userId in
I'm getting an error at this statement: cursor.execute("SELECT * FROM dbo.User") Error: pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Driv