Questions tagged [ssms]

Microsoft SQL Server Management Studio is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server.

7,084 questions
0votes
1answer
6views

How do I write queries for data in tables that already contain relationships?

I am using SQL Server and SSMS. I have a table called PersonsTable. PersonID FirstName Surname Age 1 Hansen Ola 30 2 Svendson Tove 23 3 ...
0votes
0answers
18views

Is there a way to write this python function for MSSQL using pure SQL in a stored procedure, without SQL Alchamey

I have a dataframe of sales data containing product_id, store_id, year, week, quantity_sold. I am able to normalize the quantity_sold and group by the columns as specified below and this gives me the ...
0votes
0answers
14views

I want advice on how to optimize a specific query. Besides the code what details will give me the best advice on Stack Overflow?

I'm trying to learn how to optimize queries. I would like to use stack overflow as a resource. If you were given the below stored procedure ( Subscription.PopulateFinancialDetail ) and told to figure ...
0votes
0answers
9views

SSMS remember dialogs / windows size

Forms like restore database, login properties, etc can be resized. Is the any way to keep those windows resized? Didn't find any corresponding option in Tools / Options. I'm using version 18.7.1
  • 1,553
0votes
0answers
22views

nvarchar to date/datetime conversion failing when using sqlconnection but not in SSMS

Is there a difference between running a query with sqlconnection in .NET and running the exact same command in SSMS on the same data? I'm getting different results. To reproduce in .NET, I have two ...
0votes
0answers
27views

Stored Procedure Automatically Calling Another Stored Procedure?

I'm working on modifying some code around and I noticed that when I go to execute a stored procedure, lets call it 'yyyyyyyyy_sproc' I get an error saying that 'xxxxxxxxxxx_sproc' doesn't exist (...
0votes
0answers
22views

SQL Server Cannot open database requested by the login (via pyodbc). But login works on SSMS

Here's my connection string: 'DRIVER={ODBC Driver 17 for SQL Server};SERVER=localhost;Database=myDatabase;UID=admin;PWD=admin;Mars_Connection=Yes' I am able to login to the database using the same ...
0votes
1answer
35views

SQL Server & RStudio - SQL Connection Almost Working

I've been running into an issue in R Studio with a SQL connection. We've had an on-prem SQL Server that's been upgraded over the years, and a colleague that set it up no longer is with the ...
-3votes
0answers
22views

What tech stack to use for developing ecommerce android app? [closed]

I am given a new project to develop and android app which is almost similar to an ecommerce app. I'm given the freedom to choose the tech stack for this but I have to use SQL Server management studio ...
0votes
2answers
39views

convert rows into columns in sql server with dynamic columns [duplicate]

I have this result Visitor name City Price Neo Japan 95,000 Neo NewYork 100,000 Neo Paris 1,000,000 I want to get this result Visitor name Japan NewYork Paris Neo 95,000 100,000 1,000,000
0votes
2answers
55views

SQL query - CASE WHEN with DATEDIFF

I have a SQL query as shown below. I would like to get the correct document count based on minutes different from the assigned date vs the current date, but I noticed the query will not count the ...
0votes
1answer
31views

Do tables automatically enable for CDC in SQL Server when I enable it for Database?

I have created a database and created a table in it. After that, I enabled CDC using exec sys.sp_cdc_enable_db for the whole database. When I checked, the database was enabled for CDC but the tables ...
1vote
0answers
32views

Accessing a local SQL Database created in SQL Server Management Studio in a c# windows form?

Here is my Code: private void button2_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection("Data Source=DESKTOP-BPRGRPB/SQLEXPRESS;Initial Catalog=Test;...
-1votes
1answer
29views

using Query one results to run Query two

SELECT distinct Pd.Cpd as ' accountnumber' FROM [RQL_ALK_PMT].[Cts_opps] pd INNER JOIN [RQL_ALK_PMT].[Cts_opps].dpo.cnms_id metg on metg.cnms_id=me.cnms_id This code would result with ...
1vote
0answers
25views

Enter Parameter Value not accepting values

I'm taking over a database and there is a process to update it, using Access as the front end connected to SSMS.Of course I'm stuck on the first part of 23, Step1A: Appends new records to ...

153050per page