home
I have a scenario where we have various orders that get completed with a start and end time. I am...
On a SQL Server on Windows EC2 instance, logging in to SSMS fails silently when using a SQL Server...
I'm new to azure and I've created a new SQL DB and I want to create a read-only user for my DB (so...
First time posting. I attempted to search for a similar scenario but I don't even know the proper...
I am just trying to migrate my laravel to sql server. I have installed Miscrosoft SQL Server. I...
I'm looking for a command which gives the list and frequency,date of scheduled jobs on all my DB...
Run ssis package having kingswaysoft component need to run in SSMS is it possible?If Possible may i...
I'm running SQL Server 2012 and am attempting to export a SSIS project from the Integration...
Can anyone help with the following? When pasting data from database to excel, there is a...
Im trying to count the number of working hours from some users for the month, the only way to do it...
I am trying to use multiple pivot in a single query on same column. Since i am using same column...
I have 5 columns and more than 10 records to save. What I tried is to insert more than 10 rows...
Need to Inventory all SQL servers that have SSMS installed 2005 to 2017; thinking of a regeread...
3 days ago

MSSQL use in PHP

I am using the following PHP code to fetch data from my mssql table: $query2 = "select kArtikel,...
where to find which stored procedures correlate with a table in SQL Server Management Studio...
I would like to change the name of a few tables. The problem is that the name of a table is...
I am using SQL Server and queries using SQL Server 2014 Management Studio. I am calling a stored...
I enable dark theme in ssms but the query resuly window and registered servers window are still...
I have SQL server 2016 standard edition SP1 and RAM,CPU all are normal when i got this message....
DECLARE @mgcounter INT SET @mgcounter = 1 WHILE @mgcounter = 1 BEGIN IF (SELECT COUNT (*) ...
I have the following table: item_ID | item_Name | Amount ---------|-------------|------- 12...
Whenever I create a SSMS project/solution and add existing files to the project, there doesn't seem...
I have two cubes. I want to inner join the main cube with the other cube and show the data from...
create table TiposPeliculas ( id_tipoPelicula int identity (1, 1), descipcion varchar...
I have a table with CountryName and an id. Eg. id CountryName ----------------- 1 ...
I am trying to connect to a SQL Server-2008 R2 version from my local computer. I opened my SQL...
I have an update statement that is returning an error Cannot insert the value NULL into column...
I am having trouble getting a stored procedure to run and get a value back from it, when I run the...
I'm experiencing a visual glitch in SSMS. Whenever I hide the results pane, the editor is covered...
Why my data doesn't appear in Browser using SSMS? I have set up everything as the steps in the...