I worked on a screen from which we can save the backup directory (C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Backup) to be able to perform
I have a very simple query that looks like this SELECT Username ,FORMAT(Timestamp, 'MM/dd/yyyy') as Date ,FORMAT(Timestamp, 'hh:mm tt') as Time FROM
I took a backup of the database on a disk from a server that I do not have online access to. Trying to restore the database on my local machine using: RESTORE
How do I send output from a database query executed in mssql-cli (the Microsoft SQL command line interface application) on a Linux machine to a text file on tha
I am working on an SSRS report and a part of my sql query is like WHERE SuperVisorId IN (@SupervisorIDs) AND CreatedDate> @StartDate where the @SupervisorID
![enter image description here][1] I have table called tbl_monthly_leave in below table i am trying to take dates between fromdt to Todate like (Fromdt , Todate
I'm trying to write a dataframe to SQL Server using the following line dbWriteTable(conn,"r_test_upload",df, field.types = c(longnotes ="varchar(max)")) By d
I want to output all the possible combination in two tables without using cartesian join or cross join. Is this possible?
I have a stored proc in SQL Server called test.storedproc My py script is as follows import pyodbc import pandas as pd conn = pyodbc.connect('Driver={SQL Server
I know this is kind of a stupid question but it gives me a lot of problems. Me and my partners in college projects have a lot of issues making the database mdf
I'm looking to create a scalar function in SQL Server (2017) that leverages a calendar table I built awhile back in order to calculate and return a date a given
Gets 'exact' banned words matched against a set of blog comments. It then creates a result set collapsing the banned words into the owner (the blog comment) sho
I have to identify the records with check_in category of S1, T1 and P1 in the check-in-order and pivot the rest of the data until we hit the next category. I wa
This is using Microsoft SQL Server 2012. I have a program that has multiple versions, each one has some schema changes to the underlying SQL database. In an at
I am doing a MERGE in SQL Server using the following code MERGE INTO DW_Datawarehouse.[dbo].[DWF_WAREHOUSE] with (HOLDLOCK) AS target USING #DataSource AS Sourc
I have 2 applications in IIS which are calling same database. When I am executing the stored procedure which has below query, it returns 2 net_addresses every
In my ASP.NET Core Web API application I have a Serilog set up to log different types of events (Information, Warning etc) into different tables in a SQL Server
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
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
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