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
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
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
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
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
I currently have this query DECLARE @user uniqueidentifier , @day_to_find int , @date DATETIME = getdate() SELECT @user = CAST(Value AS uniqueidentifier) F
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
I am using SQL Server DB (mssql), And trying to execute Insert Query through PHP. public function registerCustomer($custId, $custData) { $sqlString = "INS
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
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
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,
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
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
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
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
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
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.
I'm using node-mssql 3.2.0 and I need to INSERT INTO a table and return the id of the inserted record. I can successfully use sql.Transaction() to insert data,
I'm trying to get monthly production using group by after converting the unix column into regular timestamp. Can you please tell how to use group by here in the
I have been trying to get rid of this problem but seems like there's no solution to this, my visual studio keeps on popping save as dialog box whenever I try to